Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 27 Answers
- 27781 Views
- I also Faced
- E-Mail Answers
Answer Posted / om patel
select (distinct(a.sal) from emp e where rownum=&N(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is data definition language?
What is sql query limit?
What is sql*loader and what is it used for?
How to use distinct and count in sql query? Explain
How do we use distinct statement? What is its use?
How to write a query to show the details of a student from students table whose
What type of database is sql?
What are triggers and its uses?
What is a full join sql?
Is sql dba a good career? : SQL DBA
Explain normalization and what are the advantages of it?
how can you see all indexes defined for a table? : Sql dba
What is dbo in sql?
How to run sql commands in sql*plus?
Explain spool.
