Write a query to find second highest salary of an employee.
- 27 Answers
- 21979 Views
- I also Faced
- E-Mail Answers
Answer Posted / arif saulat
select * from emp where sal <(select max(sal) from emp)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the key differences between SQL and PL SQL?
How bulk collect improves performance?
what are date and time intervals? : Sql dba
How do you write an index?
What is right join sql?
What are local and global Indexes and where they are useful.
How much does sqlite cost?
What is difference between cursor and trigger?
How do I start sql profiler?
What is procedure and function?
What is a clob in sql?
What are the three forms of normalization?
What is example of database?
What is the difference between sql and mysql?
What are the sql aggregate functions?
