how to find the second highest salary from emp table?
Answer Posted / sachin verma
select sal from emp
where rownum=2
order sal by Desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Does sql view stored data?
what is the different between now() and current_date()? : Sql dba
Explain architecture of sql server notification services?
How exception handling is done in advance pl/sql?
What is a nested table in word?
Why is sql*loader direct path so fast?
What are inbuilt functions in sql?
What is a relationship and what are they?
what are the nonstandard string types? : Sql dba
How many types of cursors are available in pl/sql?
How many types of indexes are there in sql?
What is difference between sql and excel?
What are the two virtual tables available at the time of database trigger execution?
What is consistency?
Is sql an operating system?