Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using result from DISTINCT SELECT
And there is a reason to have Distinct, There is just a bug in DB2 Imagine there are two values like 5 , 5 , both of those will be choosen, but for a DISTINCT select, it should only take out one of those lines, unfortunately DB2 cannot handle that and will give a DISTINCT select with two equal... -
Using result from DISTINCT SELECT
Was it that unclear? I found how to do it anyway: Select a, b, c from 2, ( select a, max(2.TIME) AS MAX from 1 , 2, where 1.a = 2.a and 1.TIME > "2008" GROUP by a) AS X where X.a = a and X.max = time; -
Using result from DISTINCT SELECT
I want to get some data, from 2 fields, but I don't want to select distinctly by them In my tables I have Table 1: A B TIME Table 2: A B C D E TIME my select is select distinct a, max(2.TIME) from 1 , 2, where 1.a = 2.a and 1.TIME > "2008" GROUP by a The problem I have is I want to get... -
Selecting All rows from one table that is not in the other
IT WORKS!!!! thank you thank you thank you thank you thank you thank you! You've said me a lot of suffering and pain, and work. You're now my hero. -
Selecting All rows from one table that is not in the other
It shouldn't be hard to do, I hope. What I want to do is this: select table1.id from table1,table2 where table1.id != table2.id .... I wish it was possible to write like that... but it doesn't I guess I can figure out the reason but anyway how should I do it? PLEAse help... example...
