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
Do you know what are different types of replication in sql server?
What method is used by the Command classes to execute SQL statements that return single values?
What the difference between UNION and UNIONALL?
What is a transact-sql statement batch in ms sql server?
How to list all objects in a given schema?
Explain about Views?
Do you know what is a linked server in sql server?
Difference between LEN() and DATALENGTH() in sql server ?
How do I schedule a sql server profiler trace?
how would you improve etl (extract, transform, load) throughput?
Can sub report data source be different from that of the parent report?
What is a with(nolock)?
What are SSL and TSL protocols?
What are the types of normalization?
What are the advantages of using cte?