/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

5 votes194 views1 answer
Sql table columns
SQL
5 votes191 views1 answer
Sql integer to serial
SQL
1 vote176 views1 answer
Partition by sql server
SQL
5 votes179 views2 answers
Update all rows mysql
SQL
15 votes181 views2 answers
How to drop database name in postgresql
SQL
0 vote169 views1 answer
How to get data between a last week in mysql
SQL
15 votes248 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote187 views2 answers
Many to many flask-sqlalchemy
SQL
34 votes211 views6 answers
Sql change data type
SQL
1 vote219 views1 answer
Mysql print variable
SQL

Share