/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 votes102 views1 answer
Select * from table where name like
SQL
0 vote97 views1 answer
Mysql server not starting in xampp in mac
SQL
0 vote162 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
2 votes104 views4 answers
Check timezone of mysql database
SQL
0 vote98 views1 answer
Create table employees oracle
SQL
23 votes100 views6 answers
Delete all rows from table sql
SQL
0 vote142 views1 answer
Cahnge column name apex oracle
SQL
0 vote109 views1 answer
Oracle webcenter content search enginer
SQL
-1 vote111 views1 answer
Window functions in sql
SQL
2 votes119 views1 answer
Sql skip the first row
SQL

Share