Sql max value in column

Sql display max value

SELECT MAX(<numeric column>) FROM <table>;
SELECT MAX(<numeric column>) FROM <table> GROUP BY <other column>;

Source: teamtreehouse.com

Sql max value in column

SELECT MAX(salary) FROM employees;
SELECT id, MAX(salary) FROM employees GROUP BY id;

SELECT t1.*
FROM employees t1
INNER JOIN (
    SELECT id, max(salary) AS salary FROM employees GROUP BY id
) t2 ON t1.id = t2.id AND t1.salary = t2.salary;

Sql set max value in column

ALTER TABLE dbo.mytable ADD CONSTRAINT CK_HAPPINESS_MAX CHECK (PokemonHappiness <= 10000)

-1

Source: stackoverflow.com

Similar codes

2 votes135 views2 answers
Postgresql get table names
SQL
0 vote115 views2 answers
Sqlalchemy core in clause
SQL
2 votes123 views1 answer
Sql server case sensitive search
SQL
-1 vote149 views2 answers
Sql truncate number
SQL
0 vote130 views2 answers
Compound operator in sql
SQL
0 vote113 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote119 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote121 views1 answer
Set column in all row mysql
SQL
0 vote117 views1 answer
Postgres where
SQL
1 vote125 views1 answer
Oracle nvl2
SQL