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
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? : Sql server administration
What is the difference between ddl,dml and dcl commands?
Is it possible to replicate data from sql server to oracle? : sql server replication
What is transactional replication?
What is the difference between composite index and covering index?
What are the difference between primary keys and foreign keys?
Mention the differences between having and where clause.
Explain contrast amongst grouped and non-bunched records?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
How exceptions can be handled in sql server programming?
What is the federation in sql azure?
How to define and use table alias names in ms sql server?
What are the benefits of filtered indexes?
what are the new features in SSRS?
How you can change a cross join into an inner join?