Skip to Main Content

Oracle Database Discussions

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!

How to write query to list all the employees of deptno 20

968339Oct 15 2012 — edited Oct 15 2012
Hi ,

I am new to Oracle...Recently I got job.... Could you please help me....


How to write a query for

1) List all the Clerks of Deptno 20 and

2) List the emps along with their exp and whose daily salary is more than 100rs
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2012
Added on Oct 15 2012
12 comments
768 views