To find second largest salary in Employee table
Answer Posted / saravanakumar
SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)
Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
How do you drop an index?
What does top operator do?
Is it possible to have clustered index on separate drive from original table location?
Do you know query execution plan?
What are the advantages of the mirroring?
How much is a sql server license?
What is replace and stuff function in sql server?
What type of locking occurs during the snapshot generation? : sql server replication
What is coalesce and check constraint in sql server?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How to find out what is the default collation in a database?
What is plan freezing?
What are types of subqueries?
How do I find query history in sql server?
what are the different stages of Report Processing?