how to get second highest salary in SQL(as/4000
Answer Posted / premchand
select max(sal) from employ where sal < select max(sal)
from employ
Is This Answer Correct ? | 34 Yes | 12 No |
Post New Answer View All Answers
What are all the different normalizations?
What is difference between ms sql and mysql?
What are tables and fields?
What are system versioned tables?
What is the difference between clustered and non-clustered indexes?
What does where 1 1 mean in sql?
What is the source code of a program?
How to place comments in pl/sql?
How do you run a query?
Why does sql need a server?
What is sp_helptext?
what is auto increment? : Sql dba
what is the difference between delete and truncate commands? : Sql dba
How do you select unique values in sql?
Show how functions and procedures are called in a pl/sql block.