Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how u can find the n row from a table?

Answer Posted / guest

select rownum,ename,sal,empno from(select ename,sal,empno from
table_name order by sal) group by rownum,ename,sal,empno
having rownum=(select count(*) from table_name

Is This Answer Correct ?    10 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the most important characteristics of pl/sql?

1171


Differentiate between % rowtype and type record.

1316


Which is better join or inner query?

1066


What is the starting oracle error number?

1066


Is ms sql is free?

1031


What are aggregate and scalar functions?

1036


Can we use insert statement in function?

1008


What is a full join sql?

1065


What is the sql case statement?

1018


What is the usage of the distinct keyword?

1228


what are the t string functions available in tsql? : Transact sql

1021


What is procedure explain with example?

971


explain the difference between bool, tinyint and bit. : Sql dba

1017


What is a table in a database?

1055


Why we use joins in sql?

987