/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

1 vote108 views1 answer
Oracle list data files
SQL
0 vote109 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
19 votes119 views6 answers
Mysql if null
SQL
0 vote112 views4 answers
Change schema in sql server
SQL
14 votes116 views4 answers
Import database through command line
SQL
0 vote102 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote101 views1 answer
Distinct data types in a table sql query
SQL
0 vote132 views1 answer
Mssql find deadlocks
SQL
0 vote113 views1 answer
Less than date query sqlachemy
SQL
1 vote118 views3 answers
Nth highest salary
SQL