CODEWITHSUNDEEP
sql-servert-sqlintmax
Saanch
Saanch

Reputation: 1844

Max int value in t-SQL

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)

Upvotes: 1

Views: 4959

Answers (2)

gbn
gbn

Reputation: 432361

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.

Upvotes: 1

Kirill Polishchuk
Kirill Polishchuk

Reputation: 56182

select * from table_name where column_name=0x7fffffff

Upvotes: 2

Related Questions