sudagn

Tuesday, May 6, 2008

Selecting the row based on the row number in sql server 2005

select * from (SELECT ROW_NUMBER() OVER (ORDER BY pkuserid ASC) AS ROWID, * FROM users) as t where t.rowid=3
Posted by suda at 7:01 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2010 (1)
    • ►  January (1)
  • ►  2009 (30)
    • ►  November (1)
    • ►  October (4)
    • ►  August (3)
    • ►  July (1)
    • ►  June (7)
    • ►  May (6)
    • ►  April (2)
    • ►  March (1)
    • ►  February (3)
    • ►  January (2)
  • ▼  2008 (75)
    • ►  December (4)
    • ►  November (2)
    • ►  October (2)
    • ►  September (7)
    • ►  August (8)
    • ►  July (7)
    • ►  June (12)
    • ▼  May (13)
      • Converting Excel Worksheets and CSV files to a Dat...
      • Send Email from Gmail in asp.net 2.0
      • Using Excel Sheets as a Database Backend
      • How to remove duplicate rows from a SQL Server tab...
      • Connection to XLS using .NET
      • Concurrency in asp.net
      • Regular Expresion validator strings
      • Client side script for selected index changed of ...
      • Recipe: Implementing Role-Based Security with ASP....
      • calander Extender AJAX Control
      • calander extender Ajax Control
      • ASP.NET 2.0: URL Mapping with RegEx Support
      • Selecting the row based on the row number in sql s...
    • ►  April (14)
    • ►  March (6)
  • ►  2007 (1)
    • ►  December (1)

About Me

suda
View my complete profile

Free website - Wix.com
Simple theme. Powered by Blogger.