how to find the second highest salary from emp table?
Answer Posted / velmurugan p
Select min(sal) from table_name where sal in(Select top 2 sal from table_name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
which operator is used in query for pattern matching? : Sql dba
what is the command used to fetch first 5 characters of the string? : Sql dba
Are subqueries faster than joins?
What is partition in sql query?
What is dense_rank in sql?
Does a primary key have to be a number?
How to pronounce postgresql?
What is int identity in sql?
Explain architecture of sql server notification services?
What is normalisation and its types?
how would you get the current date in mysql? : Sql dba
Which certification is best for sql?
How to check if a column is nullable before setting to nullable?
What is the primary use of normalization?
What is the use of function in sql?