[R] Some SQL Challenges
Michael Yutzi
abcddp at gmail.com
Wed Aug 5 20:54:54 CEST 2009
To insert values with SQL: INSERT INTO table_name VALUES (value1, value2,
value3,...).
To deal with those date problems Im almost sure that R has a Date Function
somewhere in its manual. You should take a look.
Just the best help I can give, sorry
good look
JoK LoQ wrote:
>
> Hi,
>
> Im trying to complete a list of jobs using SQL Querries and some "if else"
> commands but im stucked in some steps. Could any of you give me some help?
>
> -in COLUMN1 change the format 20JAN2000:00:00:00 to 20JAN2000 and exclude
> every row that date is different from 20.
> -extract the first character in COLUMN2 and creat COLUMN3 with that value
> ex:
> COL2,COL3
> 135,1
> 461,4
> 247,2
> -in every row in which COL3=5, value in COLUMN4=value in COLUMN5
> -create COLUMN7 where if COLUMN6="north" then COLUMN7 value="N" else
> COLUMN7 value="X"
>
> Ill be grateful for any help, thnks
>
--
View this message in context: http://www.nabble.com/Some-SQL-Challenges-tp24795946p24834191.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list