/SQL/Sql max count

Sql max count

Sql max count

SELECT max(MY_COLUMN) FROM my_table; 
SELECT MY_ID, max(MY_COLUMN) FROM my_table GROUP BY ID;   -- Max by MY_ID

0

Find max number in sql

● SELECT first-name, MAX(salary)
FROM department d LEFT OUTER JOIN employee e ON (d.department_id = e.department_id)
GROUP BY department_id;

0

Similar codes

21 votes219 views4 answers
Add column mssql
SQL
2 votes200 views2 answers
Postgres trigger insert into another table
SQL
7 votes219 views1 answer
Oracle reset sequence
SQL
0 vote206 views1 answer
Turnicate in mysql
SQL
0 vote202 views1 answer
Postgresql combine values in one field
SQL
2 votes202 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
1 vote306 views1 answer
Sql server delete top 1000
SQL
0 vote198 views1 answer
Fill up postgres db
SQL
1 vote258 views1 answer
Mysql stop password policy
SQL
8 votes204 views1 answer
Oracle create datafile
SQL

Share