Discussion Forum | Board Infinity
How do I find the second highest salary in employee table?
Data Science, AI and ML
sql
,
data-wrangling
chirag-garg
(Chirag Garg)
11 June 2022 17:50
1
There are multiple ways to find the second highest number from a table.
Using MAX
Screenshot 2022-06-11 at 11.19.25 PM
1108×294 28.5 KB
Using COUNT
Screenshot 2022-06-11 at 11.19.49 PM
1084×94 7.89 KB