Select Max(SAL) FROM emp WHERE sal<(SELECT MAX(SAL) FROM emp) <

To find second largest salary in Employee table

Question Posted / ela tiku

Answer Posted / ela tiku

Select Max(SAL) FROM emp WHERE sal<(SELECT MAX(SAL) FROM
emp)

<<<assuming sal is the column name and emp is the table
name>>>

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the differences between stored procedure and the dynamic sql?

1095

Can we perform backup restore operation on tempdb? : sql server database administration

999

Is a primary key unique?

992

What is store procedure? When do you use?

937

How many types of functions are there in sql server?

947

Is ssrs support other database except ms sql server?

140

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1079

What is difference between join and natural join?

972

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1006

How to check if a table is being used in sql server?

965

Why do you want to join software field as you have done your BE in Electronics?

2145

What is an inner join?

984

Does group by sort data?

902

Why do we use functions?

915

Where can you find the error log information? : sql server database administration

1026