SQL Help

[hrm]

machan me approach try karapan.

habay math meke output gaththe ne. gedara DB ekak install karala ne.
result set eka adjust karaganin group by clause eka one widiyata change karagene.
meka ubata nikam idea ekak ganna witharai danne mata test karaganne widiyak nethi nisa.
Oracle wala nam sysntax tikak wenas wenewa. ehema unoth DECODE function eka use karapan.

SELECT t1.id, t1.name, t1.team,
t2.month, MAX(t2.year) ,
'OT' = case t2.type
when 'OT' then t2.type,
'Incent'= case t2.type
when 'Incent' then t2.type
FROM Table1 t1 INNER JOIN Table2 t2
ON t1.id = t2.id
GROUP BY t1.id, t1.name,t1.team, t2.month

 

[chint]

drop table1
go
drop table2
go

troll !

 

[kosandpol]

drop table1
go
drop table2
go

yeah, this will fix any sql problem

 

[helo256]

select * from table1 , table2 ORDER BY table2.YEAR

 

[twisted]

try this, I've no sql at home, so couldn't check. and this doesn't check for max month.

select table1.id,table1.name,table1.team,table2.month,table2.year,table3.amount as ot,
table4.amount as incent
from table1 join table2 on table1.id = table2.id join
(select id,max(year),amount from table2 where type = 'ot' group by id,year,amount) table3
on table2.id = table3.id
and table2.year = table3.year join
(select id,max(year),amount from table2 where type = 'incent' group by id,year,amount) table4
on table2.id = table4.id and table2.year = table4.year

 

[twisted]

troll !

I beg to differ

yeah, this will fix any sql problem

it has worked for me

 

[twisted]

DECODE(T2.TYPE,'ot',T2.AMOUNT) AS OT

=

( CASE T2.TYPE WHEN 'ot' THEN T2.AMOUT )


would work, give it a try

machan me approach try karapan.

habay math meke output gaththe ne. gedara DB ekak install karala ne.
result set eka adjust karaganin group by clause eka one widiyata change karagene.
meka ubata nikam idea ekak ganna witharai danne mata test karaganne widiyak nethi nisa.
Oracle wala nam sysntax tikak wenas wenewa. ehema unoth DECODE function eka use karapan.

SELECT t1.id, t1.name, t1.team,
t2.month, MAX(t2.year) ,
'OT' = case t2.type
when 'OT' then t2.type,
'Incent'= case t2.type
when 'Incent' then t2.type
FROM Table1 t1 INNER JOIN Table2 t2
ON t1.id = t2.id
GROUP BY t1.id, t1.name,t1.team, t2.month

how is case expression going to solve this? afaik, it doesn't produce two separate columns and then may be it does, I'm such an IT noob

 

[¤--bACarDi--¤]

try this, I've no sql at home, so couldn't check. and this doesn't check for max month.

select table1.id,table1.name,table1.team,table2.month,table2.year,table3.amount as ot,
table4.amount as incent
from table1 join table2 on table1.id = table2.id join
(select id,max(year),amount from table2 where type = 'ot' group by id,year,amount) table3
on table2.id = table3.id
and table2.year = table3.year join
(select id,max(year),amount from table2 where type = 'incent' group by id,year,amount) table4
on table2.id = table4.id and table2.year = table4.year

 

[¤--bACarDi--¤]

use 2 CASE expressions then

 

[twisted]

use 2 CASE expressions then

s-cual koory is fun

 

[hrm]

how is case expression going to solve this? afaik, it doesn't produce two separate columns and then may be it does, I'm such an IT noob

Just want to give some support for the guy who posted this thread. I might be wrong since I don't have any way to run and see the out put or an ERROR.
I'm not a SQL guru.

 

[twisted]

Just want to give some support for the guy who posted this thread. I might be wrong since I don't have any way to run and see the out put or an ERROR.
I'm not a SQL guru.

dude get over it, nobody's blaming you, your help is much appreciated, even I'm not sure If my koory was correct

 

[hrm]

dude get over it, nobody's blaming you, your help is much appreciated, even I'm not sure If my koory was correct

Your solution is much better. It's always good to criticize in a supporting way . btw must mind my own business rather

 

[¤--bACarDi--¤]

why don't you guys use SQL koories to blame each other!

 

[kosandpol]

why don't you guys use SQL koories to blame each other!

like this ?

Select 'you are the complete bag of shit'

 

[twisted]

Your solution is much better. It's always good to criticize in a supporting way . btw must mind my own business rather

there should be a better way

why don't you guys use SQL koories to blame each other!

update ek_members
set gender = 'shemale'
where userid like '%bacardi%'

 

[hrm]

why don't you guys use SQL koories to blame each other!

nice thought

 

[¤--bACarDi--¤]

like this ?

Select 'you are the complete bag of shit'

yeah, more advanced one

select shit
from shitpit
where smell = 'Baaaad'

 

[¤--bACarDi--¤]

update ek_members
set gender = 'shemale'
where userid like '%bacardi%'

DB constraints violated

 

[hrm]

mata me attach karala tiyena result eka ganna script ekak dennako


Result eke enna ona max (year) eke max (month) eke figures

machan you can also use T-SQL for this if a simple query doesn't serve the purpose.
(group by clauses in simple queries tend to give some unexpected results when your data set becomes larger
with possible duplications.)