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

select * from emp where empid >=5 and empid <=7

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the properties and different types of sub-queries?

990


Why we use the openxml clause?

991


How to stop log file growing too big?

996


Explain the properties of subqueries in sql server?

1057


Do you know the capabilities of cursors?

1131


What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1118


Write a query for primary key constraint with identity key word?

1011


How to get the definition of a user defined function back?

1028


What is sql stored procedure?

1062


What are the disadvantages of primary key and foreign key in SQL?

1087


What is a select query statement in ms sql server?

1047


Does index speed up select statements?

999


What are the steps you should follow to start sql server in single-user mode?

877


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2193


Can primary key be a foreign key?

1036