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 select 5 to 7 rows from a table, which contains 10 rows?

Answer Posted / govind

select * from emp where empid between 5 and 7

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is triggers in ms sql server?

1113


Explain a checkpoint?

1026


What are different types of views?

944


What is the default fill factor value?

1075


What is the difference between set and select?

1089


Explain transaction server isolation?

1033


Where are SQL server users names and passwords are stored in sql server?

1259


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1072


What are the new scripting capabilities of ssms? : sql server management studio

1060


Tell me what are cursors and when they are useful?

953


What is the difference between for xml raw and for xml auto?

1028


What is a trigger what are the advantages of trigger?

995


What is the xml datatype?

1053


What are the dmvs?

1010


What does set rowcount do?

902