Skal virksomheder stå stærkere mod angreb og kunne udvikle sig, skal sikkerhed, drift og forretning tænkes sammen. Det er tanken bag Jysk IT’s ambition om at skabe en “sikker fremtid” for kunderne.
"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.
