| Other SQL PLSQL Interview Questions |
|| Asked @
|What is difference between TRUNCATE & DELETE?
|What are different types of refreshment techniques of
|How to remove duplicate rows from a table?.
|What is difference between a Cursor declared in a procedure
and Cursor declared in a package specification ?
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
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..
|What are the different types of joins and explain them
|how to retrieve last tree records from table?
select *from emp where rownum > (select count(*)-3 from
i am using this query to get last three records from table
but its not giving any output, so please tell me what is the
error in this query.
|four procedures is are there should i write their in a package
|write a query to display diference between two dates in sql
|What is a REF CURSOR? Compare strong and week ref cursor types.
|display records from 5 to 9 using rowid or rownum
|What is the diffrence between IN and EXISTS.which one is
|For more SQL PLSQL Interview Questions Click Here |