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 / swastik

SELECT * FROM
          (
           SELECT ROWNUM Rn, E1.*
           FROM Emp
           )
WHERE RN = 5
/

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between microsoft sql and mysql?

919


How much does sql cost?

928


what is an index? : Sql dba

927


What are some predefined exceptions in pl/sql?

1057


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

985


How do I write a sql query in pgadmin 4?

923


What trigger means?

926


Write a query to find the names of users that begin with "um" in sql?

923


What is pessimistic concurrency control? : Transact sql

1023


What are sql procedures?

962


Is primary key a clustered index?

909


what is msql? : Sql dba

939


Can you upgrade sql express to full sql?

994


Is sql procedural language?

919


Does execute immediate commit?

1150