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

A table has 150 records. How do you retrieve 100th row to
120th row from that table ?

Answer Posted / sum

select * from employees where rownum between 100 and 120

Is This Answer Correct ?    2 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we write dml inside a function in sql server?

1004


What is the difference between a query and a report?

1063


Why we use pl sql?

1009


What are the different types of joins in sql?

1916


what's the difference between a primary key and a unique key? : Sql dba

1114


how do you tune the slow running queries in oracle db , explain the methodology

3240


What is a full join?

1048


What is pl/sql table? Why is it used?

1096


How long does it take to learn pl sql?

1108


Why we use stored procedure instead of query?

1050


What is the difference between syntax error and runtime error?

1185


what are date and time data types? : Sql dba

1031


Can variables be used in sql statements?

1075


How to write pl sql program in mysql command prompt?

1165


What are the packages in pl sql?

1067