Select Querys

[Mikalux]

Can anyone tell me, how to find the highest value (integer) in a mysql db?

Does anyone know a good page, where are some select examples as distinct...?

Thank you very much!

Mikalux

[Frag]

You really should RTFM.

http://www.mysql.com/documentation/mysql/bychapter/

For your answer comes within the manual.

http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#example-Maximum-row

[Mikalux]

very good help....

mikalux

[MytchE]

SELECT MAX(fieldName) FROM TABLENAME WHERE 1=1

That should do it 😃

[Mikalux]

Thank you very much for helping me!!

This select query is working fine :-)

Mikalux