write a query for the fifth highest salary?
Answer Posted / suparna
select salary from employee e where 4=(select count(*) from
emp f where e.sal<f.sal)
Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
diff b/w inter process and in process
WHAT IS CARDINALITIES OF JOIN?
What are the advantages of using database?
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
Define stored procedure?
What is a reference table in database?
What is the function of cluster index?
Explain alternate key?
What is dialect in database?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
What is the database url?
What is the importance of database partitioning?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?