how to select 5 to 7 rows from a table, which contains 10 rows?
Answer Posted / john t
If you knowfor sure that the number of rows is 10 then the
above answers given above a great examples. So what if you
don't know the total number of rows in that table? Can you
use Select count(*) from nameoftable;
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the significance of master, tempdb and model databases?
Can we store videos inside the sql server table?
How to find the version of sql server? : sql server database administration
What is compression - row-level and page-level compression?
How do you improve the performance of a SQL Azure Database?
What is de-normalization in sql database administration? Give examples?
What are security principals used in sql server 2005?
Explain primary key and foreign key constraints?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
How can I change procedure name in sql server?
Do you know what are the reporting services components?
What are the recovery models in sql server 2000?
Do you know how to store and query spatial data?
Why are views required in the sql server or in any other database?
what is the difference between Delete and Truncate command in SQL