To get second row from a table

Submit Code |

Search Codes |

Code Home |

select top 1 * from (select top 2 * from EmpDetails1 order by empid) q order by empid desc

Regards,
Denny Kurian

Found interesting? Add this to:

| More | Bookmark It

>> Write Response - Respond to this post and get points

More codes snippets
	Multiply two number with out using multiplicative operator to get brower information in C# to get brower information insert directly from application to database Clone The Div to Another Div ??? Move the Child of source div to target div Move to Target Div Copy from one div content to another content Addtion of time(in nvarchar format) using Sql server 2008 Submit Code \| More ...

General Notice: If you find plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.

Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 5/25/2013 5:18:43 PM

To get second row from a table

More codes snippets