/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 vote223 views1 answer
Set Mamp mysql globally
SQL
0 vote218 views1 answer
Select lowest values sql
SQL
1 vote235 views3 answers
Sql procedure
SQL
8 votes172 views1 answer
Similarities between ddl and dml
SQL
0 vote225 views1 answer
Mysql Like(searching in the string)
SQL
1 vote229 views2 answers
Maximum number of tables in mysql
SQL
0 vote219 views1 answer
Postgres declare variable
SQL
7 votes224 views1 answer
Mysql remote connection command line
SQL
0 vote195 views1 answer
Postgres get running query
SQL
0 vote213 views1 answer
Sql beginning of previous month
SQL

Share