how to find the second highest salary from emp table?
Answer Posted / atheeq
select distinct emp_sal from emp where 1 order by emp_sal
desc limit 1,1
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
What is difference between inner join and cross join?
What is the use of sqldataadapter?
What type of join is sql join?
Could you please provide oca (oracle 10g) dumps for my certification ?
Explain isolation levels. : Transact sql
Can you skip header records while loading? : aql loader
What are types of exception?
What is cursor status?
What does rownum mean in sql?
Which constraints we can use while creating database in sql?
Can we write ddl statements in functions?
What does stand for in sql?
Which are the different case manipulation functions in sql?
What is the sql case statement?
How to pipe multiline string to isql?