Question of the day: Creative Self Join in SQL

• E-265618

  SSC Journeyman

  Points: 91

  More actions

  October 11, 2005 at 3:43 pm

  #166249

  I found this scenerio that I found intriguing. . .

   

   

  EVENT
  EventID	EType	ETime

   

  n

  Write a query which returns:

   

  Sequence#,  EventID, EType, ETime  (Sequence# is 1 for the 1st event, 2 for the 2nd, etc.)

   

  You can assume that no two events happen at exactly the same time.

• philcart

  SSC-Forever

  Points: 47797

  More actions

  October 11, 2005 at 9:15 pm

  #596700

  Please do not cross-post.

  See my response here

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=228157

  --------------------
  Colt 45 - the original point and click interface