use MAX function - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

use MAX function

Author

Topic

nielsvd
Starting Member

1 Post

Posted - 2004-07-08 : 06:19:39

I have this select statement.
SELECT DISTINCT
tblExamenDeelname.ExamenDefinitieID, tblBeheerder.Voorletters, tblBeheerder.Tussenvoegsel, tblBeheerder.Achternaam, tblBeheerder.EmailPrimair
FROM ...

I want to add this select line to it, but I don't know how to accomplish

MAX(tblExamenDeelname.VersieNummer)

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2004-07-08 : 06:28:28

SELECT
tblExamenDeelname.ExamenDefinitieID, tblBeheerder.Voorletters, tblBeheerder.Tussenvoegsel, tblBeheerder.Achternaam, tblBeheerder.EmailPrimair,
MAX(tblExamenDeelname.VersieNummer)
FROM ...

group by tblExamenDeelname.ExamenDefinitieID, tblBeheerder.Voorletters, tblBeheerder.Tussenvoegsel, tblBeheerder.Achternaam, tblBeheerder.EmailPrimair,

CiaO

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources