[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