Viewing 8 posts - 1 through 8 (of 8 total)
Eric M Russell (10/27/2015)
October 28, 2015 at 4:43 am
leroux 56837 (10/23/2015)
October 26, 2015 at 11:04 am
The Wizard Of Oz (6/6/2014)
ben.norris (6/6/2014)
The Wizard Of Oz (6/6/2014)
It would be...
June 6, 2014 at 8:36 am
The Wizard Of Oz (6/6/2014)
It would be strange if someone caught SwePeso...
June 6, 2014 at 8:18 am
SELECTCustomerID
FROM#Purchase
WHEREProductCode IN ('A', 'B', 'C')
GROUP BYCustomerID
HAVINGMIN(ProductCode) = 'A'
AND MAX(ProductCode) = 'B'
--AND COUNT(*) = 2;
This relies on A, B and C being ordered rather than some arbitary values that happen to...
June 6, 2014 at 8:00 am
craig 81366 (10/30/2012)
ben.norris (10/30/2012)
Hugo Kornelis (10/30/2012)
ben.norris (10/30/2012)
It doesn't state that the field is nullable
First: It does. The CREATE TABLE script does not include a NOT NULL constraint, so the columns...
October 30, 2012 at 6:31 am
Hugo Kornelis (10/30/2012)
ben.norris (10/30/2012)
It doesn't state that the field is nullable
First: It does. The CREATE TABLE script does not include a NOT NULL constraint, so the columns are all nullable.
Second:...
October 30, 2012 at 6:13 am
An interesting question spoilt by the 3 points of ambiguity.
Salesgoal mistake
The Sales value for easy becomes 100, it is xray that is missing.
It doesn't state that the field is nullable
October 30, 2012 at 5:22 am
Viewing 8 posts - 1 through 8 (of 8 total)