To find second largest salary in Employee table
Answer Posted / kuduba.r
select max(salary) from emp where sal<(select max(salary)
from emp)
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is dirty read?
What are the two modes of authentication in sql server?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is explicit mode in sql server?
What is the library index called?
Does sql server use java?
What are drilldown reports?
What is ssrs?
What are the different types of sql server replication? : sql server replication
what are the core components of SSRS?
Equi join and non equi join is possible with sql server?
Can a cursor be updated? If yes, how you can protect which columns are updated?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What happens if null values are involved in arithmetic operations?
Write a query to find 5th highest amount paid from the customer table.