Cyber Infrastructure (CIS) Interview Question: Get the last thee max salaried person from table via sql.

Notifications

Cyber Infrastructure (CIS)

Get the last thee max salaried person from table via sql.

Anonymous

5 Sept 2016

Just call select query with order by salary with 3 rows limit.

Anonymous

12 Dec 2018

select top 3 salary from employee order by salary desc

Anonymous

6 Jan 2019

"select sal from employ order by sal dec limit 3;"