Max int value in t-SQL

Question

I want to verify the Max value of int with the column value is it possible?
eg:- select * from table_name where column_name= Max(int)

Kirill Polishchuk · Accepted Answer · 2011-09-20 04:52:59Z

2

select * from table_name where column_name=0x7fffffff

answered Sep 20, 2011 at 4:52

Kirill Polishchuk

56.4k11 gold badges125 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-04-13 12:42:38Z

1

I'll assume you want the row with the highest value, not the actual 2^31-1 value

SELECT TOP 1 *
FROM table_name
ORDER BY column_name DESC

If you have multiple values with the highest, to get all

SELECT TOP 1 * WITH TIES
FROM table_name
ORDER BY column_name DESC

Let us know if you want highest per a group or other column: can be done too.

CommunityBot

11 silver badge

answered Sep 20, 2011 at 5:21

gbn

435k84 gold badges602 silver badges690 bronze badges