Introduction
SQL is a language in the computer world. When developing reports using relational databases, you need SQL knowledge to put data into databases and obtain data from databases. Many people use SQL in a careless manner and do not realize how powerful a weapon they possess. This book aims to open the reader's perspective and see what SQL can do to change this situation.
This book is a guide that contains a series of common SQL problems and their solutions, hoping to help readers in their daily work. This book includes the sections of the relevant topics. If you encounter new SQL problems that cannot be solved, you can first find the most suitable chapter and view the titles of each section, hope that you can find a solution and at least find some inspiration.
There are more than 150 sections in this book, which is just a scale of what SQL can do. The number of solutions to daily programming problems only depends on the number of problems to be solved. This book does not cover all problems, and in fact it is impossible to cover them; however, we can find many common problems and their solutions. These solutions use many techniques, when you learn these skills, you can extend them and apply them to other new issues that cannot be covered in this book.
There is no doubt that the goal of this book is to let readers see how much SQL can do is generally considered out of the scope of SQL problems. In the past 10 years, SQL has gone a long way, and many typical problems that can only be solved using C, Java, and other procedural languages can now be solved directly using SQL, however, many developers are not aware of this fact. This book aims to help you realize this.
Now, before misunderstanding of my words, I want to declare that I am a loyal believer in the doctrine "if it is not bad, do not repair it. For example, if you have a specific business problem to solve, you only need to retrieve data using SQL, while other complex business logic is completed in other languages. IfCodeNo problem, and the performance is also good. Thank God. I have no intention of suggesting that you discard the previous Code and try again to find a complete SQL solution. I just ask you to open your mind and realize that the SQL used for programming in 1995 is not the same as that used in 2005, today, SQL can do much more.
List the contents of this book so that you can use it as a tool book for query. Because this book contains a large number of files, you need to leave an email for this book!