/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

0 vote228 views1 answer
Psql datestyle
SQL
1 vote235 views1 answer
Postgres power
SQL
0 vote251 views1 answer
Yesql
SQL
2 votes248 views2 answers
Mysql bidirectional composite primary key
SQL
0 vote230 views1 answer
Groupby error in mysql
SQL
0 vote239 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote222 views2 answers
Sql server select where date
SQL
0 vote234 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
4 votes220 views1 answer
Oracle user tables
SQL
19 votes240 views6 answers
Sql drop table if exists
SQL

Share