how to find the second highest salary from emp table?
Answer Posted / hitesh
select top 1 salary from t1 where salary in(select top 2
salary from t1 order by salary desc)order by salary asc
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Enlist some predefined exceptions?
Why do we use sqlite?
What is the sql*loader? : aql loader
How to test for null values?
How does a covering index work?
what is sql in mysql? : Sql dba
How do I remove duplicates in two columns?
Will truncate release space?
how to use regular expression in pattern match conditions? : Sql dba
What is the difference between between and in condition operators?
What is the difference between delete and truncate commands?
What kind of join is join?
Show the cursor attributes of pl/sql.
What does pl sql developer do?
Can we insert data into view?