/SQL/Sql Top 5 sutradara dengan filem terbanyak

Sql Top 5 sutradara dengan filem terbanyak

SELECT director.dir_id,director.dir_fname,director.dir_lname,movie_direction.mov_id FROM director INNER JOIN movie_direction WHERE director.dir_id=movie_direction.dir_id GROUP BY director.dir_fname ORDER BY movie_direction.dir_id LIMIT 5;

Similar codes

0 vote106 views1 answer
Generate sequence number in sql server
SQL
0 vote125 views1 answer
The fetch keyword oracle
SQL
0 vote93 views1 answer
Frename oracle
SQL
0 vote107 views1 answer
How to write triggers to increment or decrement the number of employees
SQL
0 vote102 views1 answer
Recover deleted data from mysql database
SQL
3 votes107 views2 answers
Sql get month name
SQL
0 vote100 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
1 vote62 views1 answer
How to run sql script
SQL
0 vote114 views1 answer
Get date from timestamp in mysql
SQL
0 vote113 views1 answer
Mysql dump for selected row
SQL