select level,max(salary) from employee where level=3 connect by prior sal

how to check the 3rd max salary from an employee table?

Question Posted / kotesh

Answer Posted / kotesh

select level,max(salary) from employee
where level=3
connect by prior salary>salary
group by level;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is your daily office routine?

2340

Can we rollback truncate?

1072

how many tables will create when we create table, what are they? : Sql dba

1140

How do I remove duplicates in two columns?

1177

Do we need to rebuild index after truncate?

1128

how to start mysql server? : Sql dba

1258

What is the current version of sql?

1091

how to use regular expression in pattern match conditions? : Sql dba

1105

define sql insert statement ? : Sql dba

1094

Can we use distinct and group by together?

1130

what are the advantages of sql ? : Sql dba

1136

what is bcp? When does it used? : Sql dba

1053

how to escape special characters in sql statements? : Sql dba

1110

what is sql server agent? : Sql dba

1175

Is primary key clustered index?

1013