/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 vote167 views1 answer
Last 6 months postgresql
SQL
0 vote169 views1 answer
Select password from user mysql
SQL
0 vote195 views2 answers
How to get max from each department in sql
SQL
0 vote183 views1 answer
ACCEPT nome PROMPT on oracle
SQL
1 vote179 views1 answer
Mysql last year
SQL
0 vote163 views1 answer
Postgres create database if not exists
SQL
-1 vote176 views1 answer
How to dump .csv file into mysql
SQL
6 votes178 views1 answer
Oracle trigger after logon on schema
SQL
0 vote171 views1 answer
How to to get current date in sql
SQL
11 votes165 views1 answer
Mysql order by two columns priority
SQL

Share