Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier.

#For example let's take a look at using a calculation in the select statement #You can see here we have the total_money_spent - we can perform calculations on this SELECT first_name, last_name, ...

SELECT first_name, last_name, salary, FROM employee_salary; #One thing I wanted to show you about the select statement in this lesson is the DISTINCT Statement - this will return only unique values in ...

Unlike the previous version of SQL Server, SQL Server 2000 lets you specify collations for almost any task, at virtually every level within a database — from table column to SELECT statement.

I'm doing this in a stored proc using SQL Server.<BR><BR>Basically, I'm executing 1 SELECT statement and if that returns any rows then I want to do a SELECT INTO #Temp With criteria A.

What’s your average success rate of getting a SQL statement right on the first try? In best case, you botched a simple statement without side effects and just have to try again with correct s… ...