How do I find the second highest salary in employee table?

Data Science, AI and ML
,
#1

There are multiple ways to find the second highest number from a table.

  1. Using MAX

Screenshot 2022-06-11 at 11.19.25 PM
Screenshot 2022-06-11 at 11.19.25 PM1108×294 28.5 KB

  1. Using COUNT

Screenshot 2022-06-11 at 11.19.49 PM
Screenshot 2022-06-11 at 11.19.49 PM1084×94 7.89 KB