Errore in query mssql

[jet]

Ottengo errore in FROM; il database è MSSQL.

SELECT * WHERE ID IN (SELECT TOP(ID) FROM gallery1 GROUP BY ID2 ORDER BY ID2 DESC) ORDER BY ID DESC

[jet]

Risolto così.

SELECT * FROM gallery1 WHERE ID IN (SELECT MAX(ID) FROM gallery1 GROUP BY ID2)

[adamsmtih321]

edit