How to write the query? [message #333525] |
Sat, 12 July 2008 03:18 |
sharathmpatil
Messages: 38 Registered: February 2008 Location: Bangalore
|
Member |
|
|
Hi
How to write the query for the following?I have a table with two columns one is commission and the other one is salary.I have to compare two columns and say whether the salary is more or commission is more.
Thanks in advance
|
|
|
|
|
|
Re: How to write the query? [message #333621 is a reply to message #333617] |
Sun, 13 July 2008 12:06 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
@EL-SAYED
please read OraFAQ Forum Guide
"How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
"Responding to Posts" section:
Quote: | When responding to questions, if it is obviously a student with a homework assignment or someone else just learning, especially in the homework and newbies forums, it is usual to provide hints or clues, perhaps links to relevant portions of the documentation, or a similar example, to point them in the right direction so that they will research and experiment on their own and learn, and not provide complete solutions to problems. In cases where someone has a real-life complex work problem, or at least it may seem complex to them, it may be best to provide a complete demo and explanation.
|
Regards
Michel
[Updated on: Sun, 13 July 2008 12:06] Report message to a moderator
|
|
|