Is there a shorter way to write the following? The “original” question follows. This was was modified may times, explicitly in hopes of stopping Y responses as a result of showing a specific use-case; and [rightly] claimed to be a confusing mess. The use-case is a TSQL query that returns an empty result set in some cases while a ‘real’
Tag: derived-table
How to find out 2nd highest salary of employees?
Created table named geosalary with columns name, id, and salary: name id salary patrik 2 1000 frank 2 2000 chinmon 3 1300 paddy 3 1700 I tried this below code to find 2nd …