/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

1 vote220 views1 answer
Sql string function update replace
SQL
10 votes240 views4 answers
Else if mysql
SQL
0 vote186 views2 answers
Script all indexes in a database
SQL
0 vote199 views2 answers
Faster mysql imports
SQL
18 votes267 views3 answers
Get the list of all tables in sql server
SQL
0 vote192 views1 answer
Mysql exception output
SQL
9 votes183 views2 answers
Default number in sql
SQL
23 votes187 views4 answers
Sql server substring
SQL
0 vote193 views3 answers
Query string not ending with with vowels
SQL
0 vote186 views1 answer
How to check which sp is running in sql server
SQL

Share