select distinct * from table_name

Delete the Records selected from the below query:

select a.*
from emp1 a, emp1 b
where a.empno = b.empno
and a.rowid < b.rowid 

shiv

Try the below query, it will give the correct output
Select * from emp where salary = (select min(salary) from (select distinct salary from emp order by salary desc) where rownum < n)

-- To get nth Highest
select distinct salary

from (select salary,dense_rank() over(order by salary desc) as sal from Table )where

This will work for only highest salary n=1 but not work for 2nd and rest nth salary...
Did you have tried this?

Code
 SELECT * FROM  (SELECT employee_id, salary, dense_rank() OVER ( ORDER BY salary DESC)  r 
  FROM employees) a 
  WHERE a.r =3 ;

Yes, a primary key can contain more than one one column. Per EF Cobb's definition, a primary key is the sole candidate key on a relation variable (table) formed from one or more attribute values (c...

in some situations...
if the selected primary key column contains unique row elements..
need only one column....
if it contains any duplicates...then we take two columns