How do I write an asp database select statement?

select * from table name where lab='101'and name='Sulfuric acid', don't know your table structure, so to give you the simplest select, you can talk about your table structure.

select top 3 * from [table] where id not in (select top 6 id from [table] order by [sort] asc) order by [sort] asc

Note that the Sort rules for the outer and inner sides should be exactly the same.

select * from school where id>6 and id<10

This condition is now set only 789Let's take a look at :)

When writing a SQL statement, you can use it repeatedly**!

The database connection should be closed after use, ASP does not automatically close the connection like high-level languages, in order to save server resources, the connection should be closed as much as possible to release the resources occupied by the connection!

You can try out the command object. For details, go to MSDN to take a look.

SQL is basically generic, that is.

sql1="select * from namesfz where flage=1"That's right.

Your statement is right on its own.

Of course you can, it's the same as if nesting;

case "100"

select case bbb

case "101"

end select

case "200"

end select

select * from (your table name) where name="Zhang San" 'This is an exact query.

select * from (your table name) where name like"Zhang San" 'This is a fuzzy query.

If you use to record the pointer name. recordcount to get the number of records associated with it.

After the query result is obtained, you can display all the information in a loop.

select * from table name where name='Zhang San'

The where phrase of select is a condition that filters the recordset that controls the display