Write a query to find second highest salary of an employee.
Answer Posted / mubin ahmad
select salary from employee e1 where 2=(select count(*)
from employee e2 where e2.salary>=e1.salary)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is bitemporal narrowing?
What are sql commands?
Why do we need pl sql?
Can we use the cursor's to create the collection in PL/SQL?
what is the difference between a having clause and a where clause? : Sql dba
Why do we create stored procedures & functions in pl/sql and how are they different?
What are the different datatypes available in PL/SQL?
Which constraints we can use while creating database in sql?
How do I audit the sql sent to the server?
what is cross join? : Sql dba
What are pl sql procedures?
Are dml statements autocommit?
How many types of cursors are available in pl/sql?
Is left join faster than join?
Can we have two clustered index on a table?