write a query for the fifth highest salary?
Answer Posted / bezalel
select salamt from
(
select rownum n,salamt from
(
select distinct salamt from emp order by salamt desc
)
)
where n=5
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is redis good for?
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it
Define stored procedure?
Explain database partitioning. What is its importance?
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
What is the difference between database and server?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
Is data lake a database?
What is replicaset?
What is ole db ado?
What is a database call?
Can a database table exist without a primary key?
Explain transaction manager?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?