How do I solve a problem where the SELECT top 1 statement in Access actually returns multiple records?

access|select| Solve | problem | statement
How do I solve a problem where the SELECT top 1 statement actually returns more than one record?




Brief description: How to solve the problem that the SELECT top 1 statement actually returns multiple records




Problem:

How do I solve a problem where the SELECT top 1 statement actually returns more than one record?


SELECT Top 9 Title,id,hit from Article WHERE DATEDIFF (' h ', [Showdateb],now ()) >=0
The first 9 can be displayed correctly

SELECT Top 9 Title,id,hit from Article WHERE DATEDIFF (' h ', [Showdateb],now ()) >=0 order by hit DESC
It's all displayed.

???

Only 4 values. A lot is 0.

Is this less than nine will be all taken out?

How to solve it???
There is no such problem in SQL Server






Reply:

Again, JET SQL is not a T-SQL statement.
Jet SQL Returns a duplicate value, that is, if the field in a table is 0, a total of 100 records, even if you use select top to return records, it also returns 100 records, because JET DB does not have the order of precedence in these 100 records, can only return Back to 100 articles. To resolve this issue, you can create an AutoNumber field (ID), and then use the
Select top 1 A,id from TableName ORDER by A,id

HTTP://ACCESS911.NET Webmaster Collection