Return all columns.
SELECT * FROM Courses
Run a SQL Select statement and limit the number of rows returned. Useful when you are not sure of how to limit the recordset to be returned and you only want to return a few rows to do some initial analysis.
SELECT TOP 10 course_designater , course_name , employee_inactivating FROM Courses
Returns a count of the total number of rows in a table.
SELECT COUNT(*) from Courses
Join two SQL Server tables together.
SELECT a.[course_name] , b.[class_start_date] , b.[class_end_date] FROM [dbo].[Courses] a JOIN [dbo].[Classes] b ON a.[course_designater] = b.[course_designater_fk] WHERE a.[course_name] LIKE '%Perl%'