Expand|Select|Wrap|Line Numbers
- SELECT distinct columnA,columnB,columnC
- FROM Table
- ORDER by columnA,columnB,columnC;
If I change the sql statement to -
Expand|Select|Wrap|Line Numbers
- SELECT distinct columnA
- FROM Table
- ORDER by ColumnA,columnB,columnC;
ORDERBY clause (columnB,ColumnC)conflicts with Distinct.
Can some one help me, please?
Regards,
Omnitha