[mysql] getting the highest integer in a column.
#1

how would i go about getting the highest integer in a column?

like there are 3 ban ids(rows) in a column i want to return the highest value in the column.
BlueG's plugin
Reply
#2

from where you want to get it? samp.ban?
Reply
#3

no from the mysql table

"Bans" the row is "Banid"
Reply
#4

SELECT MAX(banid) FROM bans
Reply
#5

Quote:
Originally Posted by Marcel
View Post
SELECT MAX(banid) FROM bans
thank you very much. you made my day
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)