top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to display employee number and names for employees who earn commission in Oracle?

+2 votes
697 views
How to display employee number and names for employees who earn commission in Oracle?
posted Jun 11, 2015 by Viswas Kumar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

select empno,ename from emp where comm is not null and comm > 0;

answer Jun 12, 2015 by Arun Gowda
...