How to generate serial no from a SELECT statement?

• sifan

  SSC Enthusiast

  Points: 148

  More actions

  December 12, 2003 at 3:49 am

  #101804

  I want generate serial no as first column from a SELECT statement.

  For example:

  SELECT LastName, FirstName FROM Employees

  In the Employees table there is no column for serial no. I want to get the output as follows:

  Srno LastName FirstName

  -------------------------------------------------------------------------

  1zzzzzzzzzqqqqqqqqqqqqqqqqqqqqqqqq

  2aaaaaaaaaaaawwwwwwwwwwwwwwwww

  3eeeeeeeeeeeeeeeeeetttttttttttttttttttttttttttttttttttttttttttt

  please help me

  Thank you,

  Shifan.

  qaqa

  
  qaqa

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  December 12, 2003 at 4:29 am

  #485909

  http://www.sqlservercentral.com/columnists/dasanka/findminmaxvaluesinaset.asp

  in here it generates a sequence number

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  December 12, 2003 at 5:47 am

  #485920

  http://www.sqlservercentral.com/columnists/glarsen/sequentialnumbering.asp

  http://support.microsoft.com/?id=186133

  --Jonathan

  
  
  --Jonathan