Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?
- 16 Answers
- 25223 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / uma
all the answers are wrong,the questions is like this there
are 100 rows they want o/p to display is in betwwen 50 and
100 are displayed
select top 100 * from tablename where empid not in(
select top 50 empid from TABLENAME)
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What will happen if a column containing char type data is changed to the nchar data type?
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
What are statistics?
What are the fixed server level roles? : sql server security
What triggers long term care?
What are SSL and TSL protocols?
What is the New in SQL server 2008?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is rtm version in sql server?
What method is used by the Command classes to execute SQL statements that return single values?
Explain how to use linked server?
What is SQL Server?
How to end a stored procedure properly in ms sql server?
what is the different types of backups available in sql server? : Sql server database administration
