Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-01791: not a selected expression

Tony007Oct 7 2015 — edited Oct 7 2015

hi am geting this error am in oracle database 11gR2

i have query like this

select distinct empno,emname from employee

order by departno

how can i work around this

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2015
Added on Oct 7 2015
9 comments
1,825 views