Explain the uses of control file.
No Answer is Posted For this Question
Be the First to Post Answer
Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin
5 Answers Deloitte, Ness Technologies,
How do you handle exceptions. Give the syntax for it?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Write a unique difference between a function and a stored procedure.
What is the usage of distinct keyword?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
Define commit?
List the different type of joins?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
How many triggers can be applied to a table?
What does truncate mean in sql?
Why stored procedure is faster than query?