/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

21 votes207 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
-2 votes259 views1 answer
Trunc in sql
SQL
2 votes289 views1 answer
Create mysql user on all hosts
SQL
0 vote204 views1 answer
Mssql disable foreign key constraint
SQL
7 votes204 views4 answers
What is my mysql version
SQL
0 vote230 views1 answer
Sql create and grant user access to database
SQL
0 vote353 views1 answer
Sqlite display data in separated columns
SQL
0 vote198 views1 answer
Procedure excute monthly oracle
SQL
2 votes196 views1 answer
Postgresql change value in column
SQL
0 vote263 views1 answer
Many rows to 1 string mysql
SQL