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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how to retrive only second row from table?

Question Posted / ravi148

Answers were Sorted based on User's Feedback



how to retrive only second row from table?..

Answer / sunita

select * from tab
where rownum=2;

Is This Answer Correct ?    18 Yes 142 No

Post New Answer

More SQL PLSQL Interview Questions

What is data control language?

0 Answers  

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

What is view? Can we update view

0 Answers  

What is trigger in sql?

0 Answers  

What is left join example?

0 Answers  

explain access control lists. : Sql dba

0 Answers  

how to rename an existing table in mysql? : Sql dba

0 Answers  

What is a table partition?

0 Answers  

How do I view a view in sql?

0 Answers  

How to run pl/sql statements in sql*plus?

0 Answers  

What is difference between inner join and self join?

0 Answers  

How do I run a sql query in pgadmin 4?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories