Need Help For Writing Query

• Sateesh Kumar Surya

  Newbie

  Points: 3

  More actions

  April 25, 2006 at 10:19 pm

  #113964

  hi all,

  I need query for the following requirement. Table1 has four columns as col1,col2,col3 and col4. I want the query to have count of col2,count of col3,count of col4 group by col1....I want result of this in a single query execution. Thanks in advance.

  Sateesh

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  April 26, 2006 at 3:45 am

  #634234

  Hi Sateesh

  If this is a homework question, please post what you've tried so we can see you've made an effort.

  In any case, please post some sample data and the result you would want for that sample data.

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.