What is the correct way to use the group by and order by clause in a prepared statement. I have a query that works in mysql but not in my program.

11/6/2012 8:58:42 AM

select * from FOLDERS_FULL_OF_WOMEN
where hotness >= 8
and badonkadonk = 'No'
group by bewb.size
order by bewb.size

11/6/2012 9:23:08 AM

you can't select * on that jammy, yo

11/6/2012 9:56:52 AM

Example

Select a.obama, b.romney,COUNT(py.years) from president as p
inner join vpresident as vp on p.president = vp.president
inner join presidentyear as py on vp.years = py.years
group by p.president
order by COUNT(PY.YEARS)

This is a copy of what I'm trying to do with different names, Why does it work if I removed the group by and order by.....

11/6/2012 10:10:45 AM

Quote :

"you can't select * on that jammy, yo"

That would make the group by pointless? Oh yeah.

11/6/2012 10:21:50 AM

Go ask Barry

11/6/2012 10:23:02 AM

nope

11/6/2012 10:37:35 AM

11/6/2012 11:10:52 AM

^ goddamnit, I actually get that

11/6/2012 12:48:37 PM

^^Sadly I too get that

11/6/2012 2:02:16 PM

my password is

' or '1'='1

11/6/2012 5:25:11 PM

^^^^ our users table got dropped in production a few months ago. man it was awesome.

11/6/2012 5:26:12 PM