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 ?

Report message to a moderator

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: 68641
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

Report message to a moderator

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 ?

Report message to a moderator

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: 3211
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.

Report message to a moderator

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: 68641
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.
/forum/fa/448/0/
Regards
Michel

Report message to a moderator

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: 2882
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?

Report message to a moderator

Previous Topic: SQL injection
Next Topic: converting row to column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 11:17:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.