The problem of using TOP in the Select statement

langfo

I use vb.net to write asp.net programs, using:
Select top 8 id, idmain, infoCategory, infobt, btColor, fbtime from info Where idmain = 1 order by fbTime desc
This statement, of which top 8 does not work,
The records are all displayed,
Master pointing,
Wait online.

shenmue024

Is it an access database?

If yes, it is because fbTime has duplicate records.

teddy123

You run this sql in the database environment to see if there will be problems!
If there is no problem, it is that there is a problem with the sql statement, you can step through and debug it.

arbuliyerlu

Do all fbTime fields have the same content?

langfo

Access library