how to find the second highest salary from emp table?
Answer Posted / arun
select distinct (a.salary) from employees a
where &N = (select count (distinct(b.salary))
from employees b where a.salary <= b.salary);
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is data stored in sql?
How we can update the view?
What is output spooling in sql*plus?
Is ms sql is free?
What is database migration?
What is dynamic sql in pl sql?
what is table? : Sql dba
how to get a list of indexes of an existing table? : Sql dba
How do you use a while loop in pl sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is normalisation and its types?
Explain the the delete statements in sql?
How do I run a sql query in pgadmin 4?
Which table is left in left join?
what are all the different normalizations? : Sql dba