please tell me the query to get details of the employee
having the second largest salary

Answer Posted / shivangi

Select max(Salary) from employeetable where salary < (select
max(salary) from Employeetable)

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is onf in normalization form?

773


in the physical file layout, where should the transaction log be stored in relation to the data file?

725


What is filestream?

741


Do you know what is lock escalation?

771


What is sql server used for?

729






Why do we backup Active Directory ?

795


What is sql server profiler trace data file?

783


What is system stored procedures?

760


What does sql server mean?

693


Do you know what are different types of replication in sql server?

740


What is similarity and difference between truncate and delete in sql?

776


What is single-user mode?

693


What is built-in function?

704


What is the purpose of the tempdb database?

754


What is forward - only cursors / read only cursor?

724