View data

xxx==============================================================================================================xxx

[Notes - SQL Queries to view all data from a table]

SELECT * FROM EmployeeDemographics
SELECT * FROM EmployeeSalary
SELECT TOP 5 * FROM EmployeeDemographics
SELECT DISTINCT(GENDER) FROM EmployeeDemographics [Notes - type of values present in tha row]
SELECT COUNT(LastName) FROM EmployeeDemographics
SELECT MAX(Salary) FROM EmployeeSalary
SELECT MIN(Salary) FROM EmployeeSalary
SELECT AVG(Salary) FROM EmployeeSalary
SELECT * FROM EmployeeDemographics WHERE FirstName = 'Jim'
SELECT * FROM EmployeeDemographics WHERE FirstName <> 'Jim'
SELECT * FROM EmployeeDemographics WHERE AGE >= 30
SELECT * FROM EmployeeDemographics WHERE AGE <= 30
SELECT * FROM EmployeeDemographics WHERE AGE <> 30
SELECT * FROM EmployeeDemographics WHERE AGE = 30
SELECT * FROM EmployeeDemographics WHERE AGE >= 30 AND Gender = 'Male'
SELECT * FROM EmployeeDemographics WHERE AGE >= 30 OR Gender = 'Male'
SELECT * FROM EmployeeDemographics WHERE FirstName LIKE 'S%' [Notes - First name start with 'S']
SELECT * FROM EmployeeDemographics WHERE FirstName LIKE 'e%' [Notes - Name contains 'e' in middle]
SELECT * FROM EmployeeDemographics WHERE FirstName LIKE 's%a%' [Notes - First which contains 's' & 'a']
SELECT * FROM EmployeeDemographics WHERE FirstName is NULL
SELECT * FROM EmployeeDemographics WHERE FirstName is NOT NULL
SELECT * FROM EmployeeDemographics WHERE FirstName IN ('Jim','Pam')
SELECT GENDER, COUNT (GENDER) FROM EmployeeDemographics GROUP by Gender
SELECT GENDER, AGE, COUNT (GENDER) FROM EmployeeDemographics GROUP by Gender, Age
SELECT GENDER, COUNT (GENDER) FROM EmployeeDemographics WHERE AGE >= 30 GROUP BY Gender
SELECT GENDER, COUNT (GENDER) As CountGender FROM EmployeeDemographics WHERE AGE >= 30 GROUP BY Gender ORDER BY CountGender [showing count for who's age 30 or bigger and grouping by gender]
SELECT GENDER, COUNT (GENDER) As CountGender FROM EmployeeDemographics WHERE AGE >= 30 GROUP BY Gender ORDER BY CountGender ASC
SELECT GENDER, COUNT (GENDER) As CountGender FROM EmployeeDemographics WHERE AGE >= 30 GROUP BY Gender ORDER BY CountGender DESC
SELECT * FROM EmployeeDemographics ORDER BY Age ASC [ascending order for age]
SELECT * FROM EmployeeDemographics ORDER BY Age DESC [descending order for age]
SELECT * FROM EmployeeDemographics ORDER BY 4 DESC [descending order for row 4]

xxx==============================================================================================================xxx

[Notes - SQL Queries to view top 1000 data from a table]

SELECT TOP (1000) [EmployeeID]
      ,[FirstName]
      ,[LastName]
      ,[Age]
      ,[Gender]
  FROM [SQLTest].[dbo].[EmployeeDemographics]

xxx==============================================================================================================xxx

[Notes - For viewing two table with specific row, here it's EmployeeID, Age, Gender]

SELECT DEM.EmployeeID, Age, Gender
FROM EmployeeDemographics AS DEM
;