/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

2 votes171 views1 answer
Sqlite indexes
SQL
2 votes151 views1 answer
Foreign key example in dbms
SQL
2 votes212 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
1 vote179 views1 answer
Oracle enable job
SQL
1 vote147 views2 answers
Procedure pl/sql
SQL
0 vote225 views2 answers
Sql unique
SQL
0 vote191 views1 answer
Login failed for user sql server
SQL
4 votes203 views3 answers
Postgres drop all tables
SQL
1 vote185 views1 answer
Mysql breakline on string
SQL
0 vote182 views1 answer
Sql server size of every table in a db
SQL

Share