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

select * from emp where EmpID between 5 and 7

Is This Answer Correct ?    7 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between rank and dense_rank?

1166


What is normalization of database?

1180


What is the stuff and how does it differ from the replace function?

1227


Do you know what is blocking?

996


How to insert new line characters into strings?

1034


When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1167


sql database suspect We have a sql database that is showing as suspect. How can we recover?

2004


What is the command to change the recovery model?

1093


what is blocking? : Sql server database administration

1090


explain different types of constraints? : Sql server database administration

1004


What is the order in which the sql query is executed?

994


What are the differences between lost updates and uncommitted dependencies?

1143


What is the difference between stored procedure and user defined functions?

1238


Explain having clause and where clause?

1101


When cursors are useful?

1172