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

If the job running very slow what is the action you do

1508


What are different types of database indexes?

613


What are the different types of sql server replication? : sql server replication

711


What is tcl in sql server?

744


How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

760






What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

674


What languages bi uses to achieve the goal?

596


What are the different types of data sources in ssrs?

155


What will be query used to get the list of triggers in a database?

644


What is SQL Azure?

93


Can primary key be null?

602


How to define output parameters in stored procedures?

625


What is sql server profiler?

662


Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

681


Explain indexed views and partitioned view with their syntax.

802