/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 votes181 views4 answers
Traduction
SQL
0 vote172 views3 answers
Java hide mysql login credentials
SQL
0 vote178 views1 answer
Oracle last connexion
SQL
0 vote170 views1 answer
Laravel migration sql dump
SQL
11 votes154 views1 answer
Get ddl materialized view oracle
SQL
0 vote200 views1 answer
Consulta alias con inner join
SQL
5 votes166 views2 answers
Get number of columns sql
SQL
0 vote179 views1 answer
Sql query use select name inside where clause
SQL
4 votes166 views1 answer
Group by mysql and concatenate string
SQL
0 vote158 views1 answer
Mysql multiple primary keys
SQL

Share