select max(salary) from emp where sal<(select max(salary) from emp)

To find second largest salary in Employee table

Question Posted / kuduba.r

Answer Posted / kuduba.r

select max(salary) from emp where sal<(select max(salary)
from emp)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

If a table does not have a unique index, can a cursor be opened on it?

915

Explain what is dbcc?

1012

How to use values from other tables in update statements in ms sql server?

1118

What are the advantages of using cte?

1016

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

967

What is postgresql server?

1006

write an SQL query to list the employees who joined in the month of January?

1677

What are distributed partitioned views?

1079

How can you list all the table constraints in a database?

938

What is scheduled job and how to create it?

995

What is autocommit mode in sql server?

1179

What does ss stand for sexually?

1086

What are the export options of ssrs?

173

How does using a separate hard drive for several database objects improves performance right away?

934

How to update multiple rows with one update statement in ms sql server?

1206