SQL query

Results 1 to 2 of 2

Thread: SQL query

  1. #1
    Join Date
    Dec 1969

    Default SQL query

    Is it possible for me to arrange the records which are in this format <BR><BR>ColA ColB<BR>A 1<BR>A 2<BR>A 3<BR><BR>to <BR><BR>A 1 2 3<BR><BR>?<BR><BR>If so, could you please give me a clue of doing that ??<BR><BR>Thank you and your help will be greatly appreciated.

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL query

    Yes, you can try doing something like this:<BR><BR>SELECT DISTINCT ColA, ColB FROM yourdb WHERE 1 = 2 (or whatever) GROUP BY ColA ORDER BY ColA<BR><BR>.. and then filtering out whatever data you do not need.. <BR><BR>Best of luck!<BR><BR>Regards,<BR>Alex<BR>DomainsBot.Com

Posting Permissions

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