problem with group by

Results 1 to 2 of 2

Thread: problem with group by

  1. #1
    Gerd Guest

    Default problem with group by

    Hi!<BR>I`ve some problems with group by. My <BR>sql="select name form Stamm_Damen" how can I group the the data by name??<BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: problem with group by

    I think you&#039re terminology is a bit off. Group By is used for aggregate functions. For example, if you are getting the names and the sums of the prices, then you would want to group by names. Are you wanting to Order by names? If so, do:<BR><BR>SELECT Names FROM TableName ORDER BY Names<BR><BR>If you want to sort in descending order, just do:<BR><BR>SELECT Names FROM TableName ORDER BY Names DESC<BR><BR>Have a great day!<BR><BR>

Posting Permissions

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