/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 votes114 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote93 views1 answer
Vbscript create ADODB.Connection
SQL
6 votes98 views2 answers
Oracle
SQL
1 vote100 views1 answer
Sql update table remove spaces
SQL
0 vote94 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
1 vote115 views2 answers
Sql drop multiple columns if exists
SQL
0 vote94 views1 answer
Restore backup "text" postgresql command line
SQL
2 votes100 views3 answers
Current month mysql query
SQL
0 vote105 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
2 votes118 views1 answer
Oracle run_duration to number
SQL