Summary
As you have seen today, functions, expressions, DML, DQL, DDL, views, conditions, and operators can be used in many combinations to obtain data from the database. We have attempted to show you several examples, which hopefully will open your mind to quicker and better ways of obtaining and manipulating data.
Keep in mind that there are many ways to perform tasks in SQL, as well as any other language. You could possibly write a SQL statement that has several lines of code, and then someone else may come up with a combination that may be only a couple of lines of code, yet you both get the same results. The bottom line is that reading, practice, experience, and experimentation help you become a SQL expert.
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition 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.
