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 Are the Main Features of SQL Azure?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Explain Capacity planning to create a database? and how to monitor it?
How to configure odbc dsn with different port numbers?
What is the function of inner join?
How we can compare two database data?
how you can configure a running aggregate in SSRS?
How do you make a trace?
What do you mean by tablesample?
How many database files are there in sql server 2000?what are they?
How check triggers in sql server?
How to add additional conditions in SQL?
Explain error handling in ssis?
What is “asynchronous” communication in sql server service broker?
What samples and sample databases are provided by microsoft?