Vælg 5 med ældste dato

SELECT TOP 5 ' FROM Bruger Order By DatoField DESC

SELECT TOP 5 * FROM Bruger Order By DatoField DESC

Hej, tak - det virker, men skal være ASC i stedet for DESC, ellers vælges de nyeste datoer :-) Kan du hjælpe med en til lige i farten, så lægger jeg lidt ekstra points.

Hvis jeg fra min tabel "Bruger" vil finde, udfra kollonnen "by", antallet af brugere der bor i hver by?

Måske noget med "Count"? Jeg har ikke prøvet funktionen før

sorry! yes your right ASC is what you need. ASC is default so you dont need to write it in the SQL.

First "by" is a reserved word so you need to use [by]

You need to make a query where you GROUP on [by]

Add the fields you want to see in the query and then press the Totals button on the menu (looks like a Z). You will see now that GROUP BY is in the Totals row for all fields. In the "brugere" column choose count instead of group by

Hope that helps

Okay, I have made it so far:

  SELECT Bruger.[by] FROM Bruger WHERE bruger.[by] = "Randers" GROUP BY Bruger.[by];

This returns a single row, "Randers". Where do I place the Count(*) ?

Ahh.. like this:

SELECT COUNT (Bruger.[by]) FROM Bruger WHERE bruger.[by] = "Randers" GROUP BY Bruger.[by];

:-)

It works fine in Access, but when I use the SQL line in my asp.net page it gives me an "BC30205: End of statement expected." error.

this should work

"SELECT COUNT (*) FROM Bruger WHERE [by] = 'Randers' GROUP BY [by]"

NOTE the town name is in single quotes!

OR
"SELECT COUNT ([by]) AS CNT FROM Bruger WHERE [by] = 'Randers' GROUP BY [by]"

does this help?

Yes - It works now! With: "SELECT COUNT (*) FROM Bruger WHERE [by] = 'Randers' GROUP BY [by]"

:-)

Thank you!