OK let\'s C, It\'s look like you have a table with Headline, id and date right? Then try this: SELECT BOOK1.headline, BOOK1.id, Count(BOOK1.id) AS Total, Max(BOOK1.date) AS Last FROM BOOK1 GROUP BY BOOK1.id, BOOK1.headline;
Well u got it right! But... My problem is that i want the result to be \"ORDER BY Last DESC\" And by using \"group by\" \"id\" AND \"headline\" the result is wrong. It must only be \"GROUP BY headline\"
I have just started using eksperten and found your un-ansewered question. If you still need help then get in touch.
Terry
Synes godt om
Ny brugerNybegynder
Din løsning...
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.