sql top problem

smith3816

select top 30 class, name, physics where class>= and class<= 22 from x order by physics desc; find out that the record is 33. This is correct, because students with the same score, I still want to match the class Do not re-order, use order by physical desc, class by asc, only 30 records are found, what is the problem?

neison

There should be only 30 repetitions

xclzc17

select all top 30 class, name, physics where class>= and class<= 22 from x order by physics desc;
Add a keyword ALL

xclzc17

select top 30 WITH TIES class, name, physics where class>= and class<= 22 from x order by physics desc;

This should work

smith3816

Brotherxclzc17, your method, I debugged it but it didn't work. In fact, my biggest doubt is: Why does a single order by physical desc have more records than an order by physical desc, and class asc?

xclzc17

Maybe the environment is different
I tried it with select top 30 WITH TIES.

xiao8342

Can the order of where and from be messed up?

xclzc17

Haha, sorry, the copy above is wrong

yourapy

1. Please confirm that the database used is sqlserver?
2. In sqlserver, if you follow the original host's wording, it does not match the original host's result. The top query of sqlserver does not have with ties by default, so top 30 will not return 33 data. I think to get 33 pieces of data, first add with ties when querying
3. Regarding the different results after sorting, it is normal. You should add with ties to both queries for comparison. For queries with top and order by, in your case, sort first, and then extract the first n data. So after you add the sort condition, in the case of with ties, the previous sort position may be duplicate records, but now it is not the same position. Naturally, no additional data is returned.