Select max(sal) from emp where sal<(select max(sal) from emp where sal&

Find out the 3rd highest salary?

Question Posted / divya c

Answer Posted / divya c

Select max(sal) from emp
where sal<(select max(sal) from emp where sal<(select max
(sal) from emp));

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is schema in sql example?

1178

Is sql easier than java?

1010

what is the difference between group by and order by in sql? : Sql dba

1128

What is on delete restrict?

1000

What are the benefits of triggers?

1172

What are the benefits of stored procedures?

1070

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1057

What is db journal file?

1064

What is join view in sql?

944

What is sql injection vulnerability?

944

Which operator is used in query for pattern matching?

1089

What is substitution variable?

1052

How to use boolean type in select statement?

1073

What is a design view?

924

Explain the steps needed to create the scheduled job?

1038