simple sql in asp

Results 1 to 2 of 2

Thread: simple sql in asp

  1. #1
    junior Guest

    Default simple sql in asp

    hi<BR>I learning asp.<BR>I have a sql/asp question.<BR>if i have a table as<BR>name hours money<BR>john 30 150<BR>harry 10 500<BR>carry 12 200<BR>john 10 50<BR>harry 20 40<BR><BR><BR>how can I get a report which writes <BR>john total hours total money<BR>carry total hours total money <BR>harry total hours total money <BR><BR>and put that querry in asp.<BR><BR>thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: simple sql in asp

    Your sql statement will look something like:<BR>SELECT name, sum(hours), sum(money) FROM yourtable GROUP BY name

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts