"Select TOP 10 Car_ID,Count(*) as votes,avg(Car_Rate), Cars.OvnerName from (carRatings inner join Cars on Cars.id=CarRatings.Car_ID ) Group by Car_ID, Cars.OvnerName order by Count(*) desc"
Select TOP 10 Car_ID,Count(*) as votes,avg(Car_Rate), Cars.Car_Owner from (carRatings inner join Cars on Cars.id=CarRatings.Car_ID ) Group by Car_ID, Cars.Car_Owner order by Count(*) desc
Select TOP 10 Car_ID,Count(*) as votes,avg(Car_Rate), Profiles.Username from ((carRatings inner join Cars on Cars.id=CarRatings.Car_ID ) inner join Profiles on Profiles.id=Cars.Car_Owner) Group by Car_ID, Profiles.Username order by Count(*) desc
Select TOP 10 Car_ID,Count(*) as votes,avg(Car_Rate), Profiles.Username, Cars.Car_slot1 from ((carRatings inner join Cars on Cars.id=CarRatings.Car_ID ) inner join Profiles on Profiles.id=Cars.Car_Owner) Group by Car_ID, Profiles.Username,Cars.Car_slot1 order by Count(*) desc
Jeg plejer at bruge MySQL's online. Den synes jeg er meget god, så længe man bare husker at funktionerne ikke nødvendig hedder det samme/eksistere i andre databaser.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
