To find second largest salary in Employee table
Answer Posted / amit
select max(salary) from employee where salary != (select max
(salary) from employee)
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
When would you prefer to have a minimum number of indexes?
what are candidate key, alternate key and composite key? : Sql server database administration
What are commonly used odbc functions in php?
Can you explain various data region available in ssrs with their use?
What is an example of a foreign key?
How do I open port 1433?
Do you know what is openxml in sql server?
What are the advantages of stored procedure in sql server?
What is a non clustered primary key?
Explain the rules for designing files and file groups in sql server?
Explain about extended stored procedure?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is a schema in ms sql server 2005?
How will you monitor replication latency in transactional replication? : sql server replication
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?