New answers tagged

1 vote
Accepted

Selecting second highest value using two SQL queries returns different results

These queries are fundamentally different. One has a scalar aggregation, and one does not. This query is selecting the first row which is not the maximum. If there is no row then no results will be ...
  • 8,860

Top 50 recent answers are included