Answer Posted / parul verma
select min(salary) from (select distinct salary from emp
where salary is not null order by salary desc) where rownum
<=100;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is exit statement?
Can unique keys be null?
How much does sql cost?
Which constraints we can use while creating database in sql?
List and explain the different types of join clauses supported in ansi-standard sql?
What is asqueryable?
What is difference between primary and secondary key?
Is it possible for a table to have more than one foreign key?
What are the two types of exceptions.
What are inner and outer joins examples of both?
What is a trigger word?
What is execution plan in sql?
What is the purpose of the partition table?
What has stored procedures in sql and how we can use it?
What are the indexing methods?