Home » Other » Training & Certification » query for commission value
query for commission value [message #284215] Thu, 29 November 2007 03:18 Go to next message
gurudevi
Messages: 2
Registered: November 2007
Location: mumbai
Junior Member

The EMPLOYEES table contains these columns:
LAST_NAME VARCHAR2 (25)
SALARY NUMBER (6, 2)
COMMISSION_PCT NUMBER (6)

I need to write a query that will produce these results:
1. Display the salary multiplied by the commission_pct
2. Exclude employees with a zero commission_pct
3. Display a zero for employees with a null commission value

can u help me ?
Re: query for commission value [message #284218 is a reply to message #284215] Thu, 29 November 2007 03:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not an Expert question.
Post what you already did, we don't do your homework for you.

Regards
Michel
query for commission value [message #284237 is a reply to message #284215] Thu, 29 November 2007 03:48 Go to previous messageGo to next message
gurudevi
Messages: 2
Registered: November 2007
Location: mumbai
Junior Member

The EMPLOYEES table contains these columns:
LAST_NAME VARCHAR2 (25)
SALARY NUMBER (6, 2)
COMMISSION_PCT NUMBER (6)

I need to write a query that will produce these results:
1. Display the salary multiplied by the commission_pct
2. Exclude employees with a zero commission_pct
3. Display a zero for employees with a null commission value

can u help me ?
Re: query for commission value [message #284240 is a reply to message #284237] Thu, 29 November 2007 03:51 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Smells like homework.

Show us what you tried so far, and where you are stuck, then maybe you will get some hints.

Re: query for commission value [message #284245 is a reply to message #284237] Thu, 29 November 2007 03:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't multipost, I already moved your previous post in Homework.
This one is locked.
./fa/448/0/
Regards
Michel
Re: query for commission value [message #284269 is a reply to message #284215] Thu, 29 November 2007 04:54 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Quote:

can u help me ?
Strange, I've had a look at the member lists and I can't find anyone called u. Are you sure that you are in the correct forum?
Previous Topic: SQL injection
Next Topic: converting row to column
Goto Forum:
  


Current Time: Tue Dec 06 10:33:27 CST 2016

Total time taken to generate the page: 0.07175 seconds