Distinct records of multiple columns

Results 1 to 2 of 2

Thread: Distinct records of multiple columns

  1. #1
    Pan Guest

    Default Distinct records of multiple columns

    I need to get the distinct records for 1 column and then distinct records of the other column. This way I have 10 columns but I don&#039;t want 10 SQL statements.<BR>Select distinct columnname1 from table <BR>Select distinct columnname2 from table <BR>How else can I get this without 10 calls to the database.<BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Create a sp

    Which will return the columns.<BR><BR><BR>in the sp you will have 10 select statements....i guess this answer COULD have been better if you told us what db you use.<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