[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,

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