how to find the second highest salary from emp table?
Answer Posted / manvar prajesh
select top 1 name,salary from emp where salary<(select
max(salary) from emp)order by salary desc
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is big data nosql?
how to escape special characters in sql statements? : Sql dba
What is the max nvarchar size?
how would you enter characters as hex numbers? : Sql dba
how to do backup entire database? : Transact sql
How does postgresql compare to mysql?
What is oracle and pl sql?
what is 'mysqlcheck'? : Sql dba
What does pl sql stand for?
Can we insert data into view?
What is sql stand for?
Can we use join in subquery?
What is sap sql?
Difference between truncate, delete and drop commands?
What is sql*loader and what is it used for?