/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 vote173 views1 answer
Recover deleted data from mysql database
SQL
-1 vote181 views1 answer
Default username and password for oracle 11g
SQL
7 votes165 views3 answers
Sql update where id
SQL
0 vote190 views1 answer
Virtuoso sql query tutorial
SQL
0 vote168 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote195 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
6 votes169 views2 answers
Drop foreign key
SQL
0 vote178 views1 answer
Mod in sql
SQL
1 vote192 views2 answers
One to one and one to many relationship
SQL
0 vote158 views1 answer
Restore backup "text" postgresql command line
SQL

Share