distinct
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: distinct

  1. #1
    Join Date
    May 2002
    Posts
    232
    hiiiiiiii,I have 3 columns no keys on that table
    columns

    a,b and c
    a contains 20rows but it has same values i mean dublicate data.
    b also have 20 records with dublicate dat.
    My question is shall i use distinct on "a" i mean (it will display five exact rows without dublication) but mean while i need to dislay all 20 records from "b".
    i hope any one can help me
    thanks
    kavitha
    kavitha

  2. #2
    Join Date
    Apr 2002
    Posts
    135
    can you display your required output.
    what do you expect for the equivalent value for b in column a.


  3. #3
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    kavita,
    can u give us an example
    "onum puriyala"
    Cheers!
    Cheers!
    OraKid.

Posting Permissions

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


Click Here to Expand Forum to Full Width