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 to find 5th row ?

Answer Posted / sanket.infy

select * from table t1 where rownum = 5 ;

Is This Answer Correct ?    1 Yes 31 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

960


What is an exception in PL/SQL? What are the two types of exceptions?

1283


What is output spooling in sql*plus?

1020


Which join is like inner join?

1009


How many types of index are there?

1021


What will you get by the cursor attribute sql%found?

953


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3991


Can %notfound return null after a fetch?

1040


How do you create a unique index?

1036


What is memory optimized table?

1032


What is the difference between unique and primary key constraints?

1054


Does inner join return duplicate rows?

962


What is lookup table in sql?

1024


Is mariadb nosql?

1032


What is raw datatype in sql?

1030