Sites: GlobalSpec.com | GlobalSpec Electronics | CR4 | Electronics360
Login | Register
The Engineer's Place for News and Discussion®

Previous in Forum: Auto Off For the PC   Next in Forum: Additional Operating System on My Computer
Close

Comments Format:






Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Participant

Join Date: Aug 2010
Posts: 1

Need SQL Help

08/19/2010 5:01 AM

select ename,sal,job and deptno of the employees

where job belongs to manager and president and tax is more than 1000..

logic to calculate tax is follows

if salary is more than 4000 then tax is 33% of sal

if salary is more than 2500 then tax is 25% of sal

if salary is more than 1500 then tax is 20%

can you help me out to write query in sql for above question

Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
Power-User

Join Date: May 2009
Location: Amarillo, Texas, USA
Posts: 194
Good Answers: 10
#1

Re: Need SQL Help

08/19/2010 1:44 PM

Check out SSWUG.ORG

Register to Reply
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Previous in Forum: Auto Off For the PC   Next in Forum: Additional Operating System on My Computer
You might be interested in: Programmable Logic Devices (PLD), Programmable Logic Controllers (PLC)