Answer Posted / aswini
select min(sal) from (select sal from emp order by sal desc) where rownum<=100
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is mutating sql table?
What is the function that is used to transfer a pl/sql table log to a database table?
What are the types of operators available in sql?
How do I turn a list into a table?
How to Declare Fixed Length String Value In PL SQL
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What does t sql mean?
What is pl/sql table? Why is it used?
What are the ddl commands?
can sql servers linked to other servers like oracle? : Sql dba
What is difference between group by and partition by?
How can we debug in PL/SQL?
What are the different dcl commands in sql?
What are the properties of a transaction?
What does bitemporal mean?
