how to find the second highest salary from emp table?
Answer Posted / gurvinder
select max(sal)from emp where sal in(select sal from emp minus select max(sal) from emp);
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how would concatenate strings in mysql? : Sql dba
what is a constraint? Tell me about its various levels. : Sql dba
Can I learn sql in a week?
what is clause? : Sql dba
How many functions are there in sql?
What are the usages of sql?
What is a join query?
List different type of expressions with the example.
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
How to pipe multiline string to isql?
What is date functions?
What is sql select statement?
How many tables can a sql database have?
Does truncate require commit?
Which query operators in sql is used for pattern matching?