Use Access Query Select Top N * from Table Order by Cols Questions!

xiaoxiao2021-03-31  208

for example:

Problem: A table table (a, b), using the SELECT TOP 5 (*) from Table ORDER BY B, if the 5 records recorded in the 5th records is the same. Then return a record of more than 5.

Solve: Add a sort condition in the order by the order, such as a general self-increment.

This problem does not exist in SQL Server2000.

转载请注明原文地址:https://www.9cbs.com/read-130914.html

New Post(0)