RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
SQL Functions
«Prev
Info Retrieval
SQL Requirements
PUBS Database
Select Statement
What is GroupBy Clause
Group by Clause Insights
Group BY vs. Sorting
SQL Subquery Statements
Subquery Statement Options
Subquery In Statement
Engine Support
Subquery Equals Clause
SQL distinct-group-by
Subquery Conclusion
Using Views show Info
SQL Select- Quiz
SQL Views
Understand SQL Views
How views are called?
View Abstraction
Select from View
Steps to Create View
Create SQL View
Updating Table Rows
Updating Table Views
Security Permissions
View Conclusion
SQL Views - Quiz
Key Sql Functions
SQL Function Overview
String | Substring Queries
Upper Lower Functions
SQL Length Function
SQL Trim Function
SQL Arithmetic Functions
SQL Sum Function
SQL Average Function
min-max Functions
SQL Date Functions
Date Function Related Issues
SQL Dateadd Function
SQL Datediff Function
SQL Datepart Function
Date Function - Exercise
Getdate | sysdate Today
SQL Function Conclusion
SQL Reporting
Course Review
Course Project
SQL Reporting Summary
Course Conclusion
String Containing Query - Exercise
Objective:
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
Submit
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
Submit
button.
SELECT au_Fname + '' + au_Lname FROM Authors
SELECT SUBSTRING(au_Lname, 1, 3) FROM Authors
Please enter your SQL into the following TextBox: