Advanced SQL queries
By following this recipe, we will learn how to use advanced SQL statements such as INNER JOIN, COUNT, LIKE, DISTINCT, and so on.
How to do it…
You can do a lot more than just perform simple queries of SQL database:
- First of all, we need to add a few tables to our database before we can dive into the programming part. Open up your web browser and access your phpMyAdmin. We need several tables for this example to work:
- I will show you the structure of each of the tables required for this project and the dummy data inserted to the tables for testing. The first table is called
branch, which is used to store the IDs and names of different ...
Get Qt5 C++ GUI Programming Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
