/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 vote188 views1 answer
Oracle list of long running queries
SQL
2 votes216 views3 answers
Sql truncate table
SQL
0 vote190 views1 answer
Run mssql server terminal
SQL
0 vote187 views1 answer
Mysql sql select one day before
SQL
0 vote193 views1 answer
Psql datestyle
SQL
0 vote143 views1 answer
Check if due date is less than todays date sql
SQL
-1 vote197 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote196 views1 answer
Partitioning in oracle-base
SQL
10 votes207 views4 answers
Primary key in sql
SQL
0 vote200 views1 answer
Plpgsql raise notice
SQL