The SQL Server SELECT statement in 60 seconds - the SELECT Clause
In 60 seconds we'll explore the SELECT clause in SQL.
My SQL Server Udemy courses are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: https://rebrand.ly/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): https://rebrand.ly/database-fundamentals
70-462 SQL Server Database Administration (DBA): https://rebrand.ly/sql-server-dba
Microsoft SQL Server Reporting Services (SSRS): https://rebrand.ly/sql-server-ssrs
SQL Server Integration Services (SSIS): https://rebrand.ly/sql-server-ssis
SQL Server Analysis Services (SSAS): https://rebrand.ly/sql-server-ssas-mdx
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
----
In this video, we're going to learn about the SQL Server SELECT statement in 60 seconds. We'll explore the SELECT clause and discuss some of its properties.
If you're new to SQL Server, or if you just want to brush up on your SELECT statement, this video is for you! We'll go over the basics of the SELECT clause in just 60 seconds, so you'll be ready to take on any SELECT task!
---
The SELECT clause is the first of the 6 principal clauses in the SELECT statement in SQL.
It lists the columns that you want to retrieve from the tables shown in the FROM clause.
If you want to retrieve all of the columns, then you can use a *
If you want to retrieve only some of the columns, they can be listed, separated by commas.
If you want to rename any of the columns in the SELECT clause, you can add the new name called an alias immediately after the original column name, or separated with the word AS. These two statements are functionally the same.
You should not put a comma between the SELECT and FROM clauses – that will create an error.
You can also add calculations in the SELECT clause.
If you do, the column name will be “(No column name)”, so you should add an alias.
If you refer to more than one data source in the FROM clause, you can use the table name before the field name, separated by a dot.
You can also restrict the number of rows retrieved by adding (for example) TOP 10 immediately after the SELECT keyword.
You can also remove duplicates by adding the word DISTINCT after the SELECT keyword.
----
Links to my website are:
70-461, 70-761 Querying Microsoft SQL Server with T-SQL: http://idodata.com/querying-microsoft...
98-364: Database Fundamentals (Microsoft SQL Server): http://idodata.com/database-fundament...
SQL Server Essential in an Hour: http://idodata.com/sql-server-essenti...
70-462 SQL Server Database Administration (DBA): http://idodata.com/sql-server-databas...
DP-300: Administering Relational Databases: http://idodata.com/dp-300-administeri...
Microsoft SQL Server Reporting Services (SSRS): http://idodata.com/microsoft-sql-serv...
SQL Server Integration Services (SSIS): http://idodata.com/sql-server-integra...
SQL Server Analysis Services (SSAS): http://idodata.com/sql-server-ssas-mu...
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model): https://rebrand.ly/microsoft-powerpiv...
1Z0-071 Oracle SQL Developer – certified associate: http://idodata.com/iz0-071-oracle-sql...
SQL for Microsoft Access: http://idodata.com/sql-for-microsoft-...
DP-900: Microsoft Azure Data Fundamentals: http://idodata.com/dp-900-microsoft-a...
Watch video The SQL Server SELECT statement in 60 seconds - the SELECT Clause online, duration hours minute second in high quality that is uploaded to the channel SQL Server 101 01 June 2023. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 1,629 times and liked it 51 visitors.
