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 are synonyms?
What is the difference between lock, block and deadlock? : sql server database administration
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is sharding?
How to optimize stored procedures in sql server?
Explain cdc and sql injection?
What is the difference between char, varchar and nvarchar?
What is difference between oltp and olap?
How you can change a cross join into an inner join?
Working with TLogs
What are diverse clauses that form a part of sql?
How to execute a sql statement using mssql_query()?
What is cross join in sql server joins?
How to delete multiple rows with one delete statement in ms sql server?
What is public role in sql server?