Sequece to know which syntax execute first

• bhaveshp.dba

  SSC Eights!

  Points: 834

  More actions

  March 23, 2012 at 7:56 am

  #270715

  Hello all,

  I want to know order for below syntax .

  means

  which condtion is satified first.

  Can Any one correct the order to execute sequece by sql server/

  1. where

  2. group by

  3. having

  4. order by

  5.from

  6 select

  SELECT Column1, Column2, Aggreate function

  FROM TableName

  WHERE predicates

  GROUP BY Column1, Column2

  HAVING Aggreate function Condition

  ORDER BY Column ASC / DESC

  Thanks

  BHavesh

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  March 23, 2012 at 8:02 am

  #1463410

  Google - logical query execution.

  Or get a copy of Inside SQL Server 2005: T-SQL Querying.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• bhaveshp.dba

  SSC Eights!

  Points: 834

  More actions

  March 23, 2012 at 8:06 am

  #1463413

  Thank you so much:-)

• Ant-Green

  SSC Guru

  Points: 113545

  More actions

  March 23, 2012 at 9:05 am

  #1463459

  this is one question I used to ask when I was interviewing, I didnt know it until I attended one of Itzik Ben-Gan's training courses in London and now its stuck with me ever since.