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

find out the third highest salary?

Question Posted / harikrishna ravipati

Answer Posted / harikrishna ravipati

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

When do I need to use a semicolon vs a slash in oracle sql?

1147

What is a tns service name?

1058

What is archive log in Oracle?

1184

How to invoke the data pump import utility?

1230

What is truncate oracle?

1016

Can I create users through internet explorer in oracle 10g?

1158

What is a system tablespace and when it is created?

1018

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2049

What is the relation of a user account and a schema in oracle?

1127

Explain the dml?

1051

How different is ms access and oracle?

1092

What is meant by joins?

1110

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2066

What is private procedure oracle?

1050

if you ctreate table identity

2430