-
-
Remove redundant rows
how to remove redundant rows without any distinct columns in the table itself ?
-
How to retrieve the 2nd record from a table ?
How to retrieve the 2nd record from a table which has say 1000 records in it. Please answer this without using the row-id? I tried to say a query "select * from table where rowcount=1" which worked well and also "select * from table where rowcount=3" which gave me the result but not when I did the same query "select * from table where rowcount=2" ? why?
-
-
SQL - Find top two salary for each department
1. top 2 salary in each dept2. 2nd maximum sal in each dept3. 2nd minimum sal in each dept.
-
PL/SQL UTL_FILE Package
Which exception is used in UTL_FILE package in PL/SQL?
-
How do you set table for read only access ?
if i am updating one record in a table at that time no other user can't able insert ,update the record in same table How is it possible
-
Find out nth highest salary from emp table
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal < = b.sal);For Eg:-Enter value for n: 2SAL---------3700
-