I'm a beginner and I need a lot of help !!

[fabio.ods]

I have to make a change in the EMP table, with the following functions:
DECODE, GREATEST AND LEAST.
where salaries from 0 to 1500 receive 10% increase and so on.

grateful for aid

[dr_gori]

Topic Moved to SQL Forum!

[ruevers]

Guys, I think I'm going to make a basic SQL tutorial ... it's bone.

What do you think and who would like to help?

[Dulima-SP]

I sent a nice material for Trevisolli ...

vê with him if it is possible to join everything in a single "guide of the beginner"

[ruevers]

I am thinking of putting the net-g tutorial on web, something very simple that teach join, update and main functions.
Something very simple indeed ... like this

by chapters
1-Understanding the Select
2-Understanding from
3-Understanding the WHERE (conditions)
4-Making Joins
5-Group by
6-Main functions.

What do you think?

[Dulima-SP]

give me your e-mail ... that I send you the material that I sent to the travisolli

[gokden]

I think it's a good idea também, tenho mtaaaaaaaaaaaaaas there, if you need help, I can send you a pouco também

more answering the question of Fábio, the decode works like this:
face, using the decode I do not know how not ...
more I managed to do this using the case

because I do not know how to put the salt> = 1500 in the decode ....
In the decode you have to do a salt = 1500 ....

using the case is like this:

Select all

 
select sal 
     , CASE 
        WHEN Sal <= 1500 THEN 
           SAL*1.1 
        ELSE 
           SAL 
        END  Sal_aumentado 
from emp

already with the decode you can do like this:

Select all

 
select sal 
     , DECODE(sal, 1500, sal*1.1, sal) sal_aumentado 
  from emp 

more there only alter the salary qui is equal to 1500

= D

[Toad]

I propose to help in this tutorial.
I have a beginner colleagues added on MSN and I usually help when I can.
With a free time, I can add the little I know in this tutorial and I'm willing to help.
Hugs!
Toad