SELECT DISTINCT SAL FROM EMP WHERE SAL = (SELECT DISTINCT SAL FROM EMP X W

Find out the 3rd highest salary?

Question Posted / ajay kumar

51 Answers
74084 Views
BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
E-Mail Answers

Answer Posted / ajay kumar

SELECT DISTINCT SAL FROM EMP WHERE SAL = (SELECT DISTINCT
SAL FROM EMP X WHERE &N= (SELECT COUNT(DISTINCT SAL) FROM
EMP Y WHERE Y.SAL>X.SAL))
/
AFTER RUNNING THE QUERY PUT THE VALUE OF N

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are the different type of normalization? : Sql dba

1029

How to fix oracle error ora-00942: table or view does not exist

1016

how to get a list of columns in an existing table? : Sql dba

966

How to rename a column in the output of sql query?

1072

How to display the current date in sql?

1082

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3053

What is sql performance tuning?

924

What is a scalar value in sql?

1076

What are the types of variables use in pl sql?

1044

What is dynamic sql in pl sql?

1038

What is sql select statement?

1036

Which data type is a composite type?

991

What is the difference between pl and sql?

1096

Why trigger is used in sql?

976

Explain the order of sql statement execution?

1049