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

3 votes277 views2 answers
Sql get month name
SQL
7 votes274 views6 answers
Nth highest salary in sql
SQL
0 vote445 views1 answer
Sql change a colum to unique
SQL
1 vote472 views2 answers
Sql unique rows
SQL
4 votes279 views1 answer
Find tables with column name in sql
SQL
3 votes273 views2 answers
Current year sql
SQL
0 vote274 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
17 votes315 views3 answers
Postgresql list users
SQL
2 votes259 views1 answer
Drop table if exists in postgres
SQL
0 vote260 views1 answer
Sql query to check if column contains alphabets
SQL