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
how to rename an existing column in a table? : Sql dba
What is trigger types of trigger?
What is a .db file?
How can we link a sql database to an existing android app?
What is gpt format?
What is the sql query to display the current date?
Which is faster joins or subqueries?
where are cookies actually stored on the hard disk? : Sql dba
What is the left table in sql?
What is meaning of <> in sql?
What is the difference between inner join and outer join?
How do you declare a user-defined exception?
What is clustered and nonclustered index in sql?
what are all the common sql function? : Sql dba
what are the 'mysql' command line arguments? : Sql dba
