What is GroupBy Clause
Group by Clause Insights
Group BY vs. Sorting
SQL Select- Quiz
SQL Subquery Statements
Understand SQL Views
How views are called?
Steps to Create View
Updating Table Row Views
Updating Table with View
SQL Views - Quiz
Key Sql Functions
Date Function - Exercise
SQL Function Conclusion
String Containing Query - Exercise
Run queries that contain string and substring functions to see how they work.
For this exercise, you are simply going to run the queries from the lesson to see how they work. They have been placed below again for your convenience.
Copy the statements and click the
button below to go to the Web site where you can run your queries. You can paste them into the text box and submit them.
When you are done running both of the queries, click the
SELECT au_Fname + '' + au_Lname FROM Authors
SELECT SUBSTRING(au_Lname, 1, 3) FROM Authors
Please enter your SQL into the following TextBox: