PDA

View Full Version : Speaking of SQL


Venom
15-04-2003, 15:30:59
Anyone know why I can't use order by when using the max aggregate function? Oh sure I can use group by, but I don't want group by I want to group by AND order by and it won't let me. Anyone? Anyone?

Venom
15-04-2003, 15:38:28
Never mind. Figured it out. Since I was using max(FieldName) in my SQL statement, for the purposes of the ordering max(FieldName) became an alias that I had to use instead of just FieldName.

You worthless tubs of crap.

zmama
15-04-2003, 15:40:50
Whadda you expect from a lab mouse?

Venom
15-04-2003, 15:49:59
More than 2 eyes and perhaps an extra leg or 2.

King_Ghidra@home
15-04-2003, 18:37:54
So you're an IT nerd too. Didn't realise that. :lol:

Venom
15-04-2003, 18:48:44
Oh lots of people knew that.

King_Ghidra@home
15-04-2003, 18:50:31
'lots of people' aren't me, thank god.

Venom
15-04-2003, 18:55:06
It's not my fault, or their fault, you've got your head firmly planted in your ass.

Resource Consumer
15-04-2003, 18:56:16
I always thought he was a nerd. Hence all the impotent threats of violence.:D

VinCent93
16-04-2003, 12:03:58
What does SQL mean?

maroule
16-04-2003, 12:11:04
If he had asked about multi threading in Java... but SQL... purely pathetic...

Venom
16-04-2003, 12:22:58
Java's a slow chunk of shit.

VinCent93
16-04-2003, 12:25:16
Java! :lol:

Darkstar
17-04-2003, 19:10:47
I don't constantly surf this threads from work, you know. Heck, when you posted this, I was still in my bed, having a good sleep. You hoser!