Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for the fifth highest salary?
- 17 Answers
- 24387 Views
- IBM, Matlabs, Ramco, I also Faced
- E-Mail Answers
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
What do you mean by cluster and non cluster index?
How to do Data integrity testing? Who does this testing (Developer or tester)?
How does database replication work?
How do you connect to a database?
A lowest level of security by most RDBMS is
What are different types of clusters present?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp
Is storing images in a database a good idea?
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
What is the purpose of firebase?
5. Explain about relational algebra.
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
List various types of log-based recovery in DBMS.
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
