/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 vote177 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
8 votes174 views3 answers
Alter table auto_increment
SQL
3 votes191 views1 answer
Oracle limit user tablespace
SQL
0 vote221 views1 answer
Sql query tags
SQL
0 vote172 views1 answer
Sql constarint
SQL
0 vote196 views1 answer
Change filed order in mysql
SQL
0 vote199 views1 answer
Oracle grant create job
SQL
0 vote209 views2 answers
What is 1=2 in sql
SQL
0 vote165 views1 answer
How to get initials in sql
SQL
0 vote179 views2 answers
Nosqlbooster query other collection
SQL