how to find the second highest salary from emp table?
Answer Posted / sarojkant
select sal from emp
where rownum=2
order by sal desc
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What does select count (*) mean in sql?
What are different types of triggers?
Name the different types of indexes in sql and define them.
Show the two pl/sql cursor exceptions.
Is sql similar to python?
Does sql between include endpoints?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What are the set operators in sql?
How to prepare for oracle pl sql certification?
How to run pl sql program in mysql?
What is pl sql and why it is used for?
what is denormalization. : Sql dba
What are the string functions in sql?
Explain alias in sql?