SQL query

• cutespn

  SSCommitted

  Points: 1669

  More actions

  April 7, 2003 at 5:42 am

  #80512

  hi,

  i have a View which contains records account name,account type,country id and funding, i need to generate a report which displays distinct account name its corresponding account type and total funding for all that corresponding account name.

  thnks in advance,

  sudheer

  
  
  
  
  
  

  Regards,
  Sudheer 
  

  
  

  

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  April 7, 2003 at 5:48 am

  #453323

  select distinct <account name>, <Account type>, sum(<funding>) as funding

  from <table_name>

  group by <account name>, <account type>

  order by <account name>, <account type>

  Jeremy

• cutespn

  SSCommitted

  Points: 1669

  More actions

  April 7, 2003 at 6:05 am

  #453325

  hi,

  thnx fo that.

  cheers,

  sudheer

  
  
  
  
  
  

  Regards,
  Sudheer