try this one n let me know.. it will delete duplicate row from the table.. delete from employee t1 where exists( select * from employee t2...
Hi.. the above query is wrong.. the correct query is select name,salary from(select name,salary,row_number() over(order by salary desc) rowno...
Hi.. its very simple.. here is the query .. select name,salary from(select name,salary,row_number() over(order by salary desc) rowno from...
Query result always will be displayed row by row.. bcz database created like this..it will be understood by every one..
if you want to find 3rd highest or nth highest then do the following query.. just try this n let me know.. select * from emp e where...
Separate names with a comma.
