|
|
|
|
|
|
|
|
|
|
version 11
This time we would like to get all the movies that are released in 1960 or more recently, and for each movie we also want additional information such as the year, title, director, media used and tickets sold. The result must be sorted by the year.
• The initial query in 4D code would be:
• Using SQL code, the above query becomes:
• Using generic SQL commands, the above query becomes:
• Using the QUERY BY SQL command, the above query becomes:
• Using the SQL EXECUTE IMMEDIATE command, the query above becomes:
To test all the above examples, launch the "4D SQL Code Samples" database and go to the main window. You can then choose the query mode and press the ORDER BY clause button.
|
|
|
|
|
|
|
|
|
|