First and Last in group function

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  February 17, 2011 at 9:19 am

  #147132

  I need to convert Access query to SQL store procedure.

  There are First and Last selection in Access Group function.

  How to code to replace First and Last in store procedure?

• GSquared

  SSC Guru

  Points: 260824

  More actions

  February 17, 2011 at 9:55 am

  #1288351

  First = Top 1

  Last = Top 1 with inverted Order By

  For example:

  select

  (select top 1 MyColumn

  from MyTable

  Order By MyColumn) as First,

  (select top 1 MyColumn

  from MyTable

  Order By MyColumn desc) as Last;

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon