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 the default value of an integer data type in sql server 2005?

953


What is built-in function?

1009


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

905


What is tablesample?

1114


You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

992


Why I am getting "the microsoft .net framework 2.0 in not installed" message?

982


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

190


Tell me what is normalization? Explain different forms of normalization?

1030


What is stored in the mssqlsystemresource database? : sql server database administration

1032


Why are sql functions used?

1124


How many columns can we include on clustered index ?

991


In which sql server version report builder introduced?

149


What is a select query statement in ms sql server?

1078


What is cursors? And what are the different types of cursor?

1145


Sql server reporting services vs. Crystal reports.

132