Interested to Buy Any Domain ? << Click Here >> for more details...
How to select nth record from a table?
- 13 Answers
- 40863 Views
- DELL, Microsoft, Ramco, I also Faced
- E-Mail Answers
Answer Posted / soorai ganesh
SELECT * FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY column_name) AS Rno,*
FROM Table_Name
)T
WHERE T.Rno = 7 -- If N is 7 other wise put ur nth value.
| Is This Answer Correct ? | 45 Yes | 9 No |
Post New Answer View All Answers
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
How many categories of data types used by sql server?
What do I need to start working with sql studio? : sql server management studio
How to transfer a table from one schema to another?
Explain what is public role in sql server?
How many columns can we include on clustered index ?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is subquery? Explain the properties of a subquery?
What is system stored procedures?
What are the types of table?
What is the use of builtinadministrators group in sql server? : sql server security
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 the transaction properties?
