Re: SELECT TOP 3 scores in each class with JOIN
During learning I was playing with MyISAM vs. InnoDB.
I made all InnoDB and all utf8_bin, probably during learning also...
There were more PK problems than that! I had keys all over the place in all my other tables too. This was probably done during learning too.
There are a lot of other columns that need to be converted to varchar. I removed a bunch of columns for the sample data. I'll have to work at that. Using uppercase has messed me up a lot. great suggestion...
as far as the results go; I was trying my best to explain that my desired results would be:
---Trophy List---
FULL SIZE GM 88 to 06
1st - 8 (65.0) Jerry Rodriguez - 2001 Chevrolet Silverado - Best Interior
2nd - 7 (59.5) Luis Rodriguez - 2003 Chevrolet Silverado
FULL SIZE GM 07 - UP
1st - 4 (62.0) Francisco Gonzalez - 1992 Chevrolet Silverado
2nd - 6 (61.0) David Villanueva - 2008 Chevrolet Silverado - Best Engine
3rd - 3 (59.5) Enrique Cruz - 2008 Chevrolet Silverado
that is top 3 in each class
removing Awards.DSQ = 1
keeping Awards.DSQ = 0
removing unclassed and disqualified and unscored
sorted first by class
then higher score first
Subject
Written By
Posted
Re: SELECT TOP 3 scores in each class with JOIN
October 02, 2016 06:27PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.