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
Is mariadb a nosql database?
Does execute immediate commit?
What is input buffer in sql*plus?
How to set up sql*plus output format in oracle?
What is before and after trigger?
How is indexing done in search engines?
Is sql easier than java?
What are data types in pl sql?
what are tables and fields? : Sql dba
What is function and procedure in pl sql?
What is the sql*loader? : aql loader
What are the types of join and explain each?
How to add a column ‘salary’ to a table employee_details?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is database sql?
