/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 votes152 views2 answers
Sql query to list all tables in a database sql server
SQL
1 vote137 views1 answer
Drop df constraint sql server
SQL
0 vote151 views1 answer
Delete duplicate rows
SQL
0 vote151 views1 answer
Datagrip exec
SQL
25 votes145 views6 answers
Sql update query
SQL
4 votes144 views2 answers
Oracle default date format
SQL
1 vote143 views1 answer
Spark sql concatenate string and int
SQL
0 vote143 views1 answer
Longtext sql
SQL
-1 vote142 views1 answer
Sql oracle take only last results
SQL
0 vote248 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL