write a query for the fifth highest salary?
Answer Posted / shahid
select *from(select sal,rank() over(order by sal desc)as sal_rank from emp) where sal_rank=5;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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 reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
Can you create a database in word?
What advantages does DBMS have over traditional file systems?
how can you perform lookup range in lookup stage expalin in detail?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
Explain various types of locks in a transaction? Which is better and why?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
Explain artificial key?
Is data lake a database?
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
What is ole db provider for sql server?
List various types of log-based recovery in DBMS.
Should I store images in database?