write a query for the fifth highest salary?
Answer Posted / prasanna
select max(sal) from emp where sal not in (select Top 4 sal
from emp order by sal desc)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Write a query to retrieve for many to many relationships?
Explain phantom deadlock?
What the various ways to tune a teradata query
How concurrency problems effect the database?
A lowest level of security by most RDBMS is
What is meant by distributed system?
What is the role of driver manager?
What is a database connection string?
What is ole db used 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
What is database server and how it works?
What is Object Oriented model?
Explain transaction manager?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
how can we view column head in first page but not in remaining pages?