Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / abhay
Select Max(Sal)
From Emp E
Where E.Sal < (Select Max(Sal) From Emp)
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is the benefit of foreign key?
What is database white box testing and black box testing?
i have some prob lem to tell me about my self in interview first round ...
What is an escape character in sql?
How do I tune a sql query?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is the difference between partitioning and sharding?
What is vector point function?
Why truncate is faster than delete?
Can we insert data in view?
How do I run a pl sql program?
What are sql functions? Describe in brief different types of sql functions?
Why procedure is used in sql?
What are stuff and replace function?
How do I enable sql encryption?