Remember
Register
1
new
Chill
new
Puzzles
new
GK
new
Sports
new
Business
Home
Questions
MCQs
Unanswered
Tags
Users
Ask a Question
Write Article
Articles
Connect to us
How to display employee number and names for employees who earn commission in Oracle?
+2
votes
788
views
How to display employee number and names for employees who earn commission in Oracle?
oracle
sql
posted
Jun 11, 2015
by
Viswas Kumar
Share this question
Your comment on this post:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
1 Answer
0
votes
select empno,ename from emp where comm is not null and comm > 0;
answer
Jun 12, 2015
by
Arun Gowda
Your comment on this answer:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
Your answer
Preview
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please
log in
or
register
.
Similar Questions
+2
votes
How to display names of employees who do not earn any commission in Oracle?
0
votes
How to display the names of all employees who are working in department number 10 in Oracle?
0
votes
Oracle: How display the names of employees who are working in the company for the past 5 years?
+1
vote
How to display employee name and annual salary for all employees?
+1
vote
Display employee number and total salary for each employee in Oracle?
...