how to write query for multiple columns in select and in group by only 1 column

• rama6452

  Newbie

  Points: 3

  More actions

  April 4, 2013 at 5:48 am

  #292045

  Hello all

  My requirement is how to write query for multiple columns in select and in group by only 1 column. In this multiple columns of select , the first column i have used distinct. But i want to group by only one column that is 2nd, or 3rd or 4 th. Please tell me any one.

  Thanks

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  April 4, 2013 at 6:05 am

  #1603504

  What grouping are you trying to accomplish (max,min,avg,sum etc) ?

  You could look at using over (partition by)