Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sajid siddiki
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal < = b.sal);
For Eg:-
Enter value for n: 100
SAL
---------
3700
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is column?
What is sql query optimization?
What are the types of views in sql?
Does asenumerable execute the query?
What are transaction and its controls?
Which sorts rows in sql?
What is sql key?
What are the key differences between SQL and PL SQL?
Why do we use procedures in pl sql?
What do you think about pl/sql?
What is a column in a table?
what is the difference between a having clause and a where clause? : Sql dba
what does myisamchk do? : Sql dba
What is graph sql?
How do rank () and dense_rank () differ?
