/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

2 votes291 views1 answer
Mysql select default if null
SQL
0 vote288 views1 answer
Sqlite explain plan
SQL
0 vote271 views1 answer
Storing RGBA in mysql db
SQL
1 vote248 views1 answer
Stored procedure return value
SQL
0 vote284 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote278 views1 answer
Mysql count grouped rows
SQL
1 vote276 views1 answer
Sql in array query
SQL
0 vote282 views1 answer
VSCode SQL Server Connection error
SQL
1 vote274 views1 answer
Oracle add proxy
SQL
0 vote271 views1 answer
Pl sql search in all packages
SQL