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

Thread: distinct

  1. 07-04-2002, 07:38 AM #1
    kavithared
    kavithared is offline Member
    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
    Reply With Quote Reply With Quote
  2. 07-05-2002, 07:00 AM #2
    sona
    sona is offline Member
    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.

    Reply With Quote Reply With Quote
  3. 07-06-2002, 12:36 PM #3
    balajiyes
    balajiyes is offline Advisor
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    kavita,
    can u give us an example
    "onum puriyala"
    Cheers!
    Cheers!
    OraKid.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width