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 the size of partition table?
What is relationship? How many types of relationship are there?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What are sql functions? Describe the different types of sql functions?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
When are we going to use truncate and delete?
Why do we use joins?
What is union, minus and interact commands?
How do you pronounce sql?
How can get second highest salary in sql?
Can we create a trigger on view?
How to take user input in pl sql?
how many tables will create when we create table, what are they? : Sql dba
what is collation? : Sql dba
how to fetch common records from two tables? : Sql dba
