Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
Answer Posted / yogesh sharma
SELECT ENAME,SALARY FROM (SELECT ENAME,SAL FROM EMP ORDER BY SALARY DESC ) WHERE ROWNUM<6;
Is This Answer Correct ? | 77 Yes | 13 No |
Post New Answer View All Answers
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 is sql injection vulnerability?
How to run sql statements through the web interface?
how to escape special characters in sql statements? : Sql dba
What is crud stand for?
How is indexing done in search engines?
How to combine two stored procedures in sql?
What steps server process has to take to execute an update statement?
What is left join example?
How delete all records from table in sql?
What does pl sql developer do?
What are %type and %rowtype for?
What is mutating error?
What is scalar and vector?
Is postgresql a server?