Distinct function in TOAD

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • stdo63
    New Member
    • Oct 2006
    • 1

    Distinct function in TOAD

    select distinct (npa+nnx)

    Can anybody tell me what the missing expression from the above statement? Or just provide any example of using distinct function in TOAD?

    Thanks a lot!
  • saravanankm
    New Member
    • Jul 2006
    • 47

    #2
    Hi

    Select qry Minimum two Clause Needed
    For Ex Select & From clause

    select distinct (5+6) from dual;

    Or

    Select distinct (xxxx + yyyyy) from Table_name;

    With Regards,
    Captain

    Comment

    Working...