{"id":202934,"date":"2025-04-24T01:10:05","date_gmt":"2025-04-24T01:10:05","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/how-to-get-row-with-max-value-in-sql\/"},"modified":"2025-04-24T01:10:05","modified_gmt":"2025-04-24T01:10:05","slug":"how-to-get-row-with-max-value-in-sql","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-get-row-with-max-value-in-sql\/","title":{"rendered":"How to get row with max value in SQL?"},"content":{"rendered":"

To get the row with the maximum value in SQL, you can use the following query:<\/p>\n

“`
\nSELECT *
\nFROM table_name
\nWHERE column_name = (SELECT MAX(column_name) FROM table_name);
\n“`<\/p>\n

This query selects all columns from a table where the value in a particular column is equal to the maximum value in that column. This will return the row with the maximum value in the specified column.<\/p>\n

\n
\n

Table of Contents<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n