how to get second highest salary in SQL(as/4000
Answer Posted / mohamed shahid
select * from (select sal,rownum rn from(select sal from emp order by sal desc)) where rn=2;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are sequences
Is sql the best database?
What is varchar used for?
Why functions are used in sql?
What is the process of debugging?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
How to load data with sql*loader?
What is numeric function sql?
What is difference between pls_integer and integer?
State some properties of relational databases?
What is the execution plan in sql?
What are the differences between in and exists clause?
What is varchar data type in sql?
Which query operators in sql is used for pattern matching?
What are different types of functions in sql?