Find out the 3rd highest salary?
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
What are types of joins?
What is snowflake sql?
How to run pl/sql statements in sql*plus?
explain what is mysql? : Sql dba
What is sql architecture?
Why we use cross join?
How to connect a sql*plus session to an oracle server?
Which query operators in sql is used for pattern matching?
What are the types of functions in sql?
What is primary and foreign key?
What are the syntax and use of the coalesce function?
What is auto increment?
What is sql procedures and functions?
What is sql lookup?
What if we write return in procedure?