/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 vote334 views1 answer
Delete double on SQL with multiple primary keys
SQL
2 votes362 views3 answers
Sql interview query questions
SQL
0 vote380 views1 answer
Hue hive UploadingTextFiletoHive
SQL
-1 vote339 views1 answer
Mysql extract days
SQL
0 vote365 views1 answer
Alter check command
SQL
49 votes405 views6 answers
Alter table add column
SQL
-1 vote394 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
2 votes342 views2 answers
Get all columns from table sql
SQL
0 vote334 views1 answer
Recursive query herarchical data sql server
SQL
0 vote334 views1 answer
Including parameters in OPENQUERY
SQL

Share