Union / Case statement - SQL code (open)
SELECT TOP (1000) [EmployeeID] ,[FirstName] ,[LastName] ,[Age] ,[Gender] FROM [SQL Tutorial].[dbo].[EmployeeDemographics] --Union select EmployeeID,FirstName,Age from [SQL Tutorial].dbo.EmployeeDemographics Union All select EmployeeID,JobTitle,Salary from [SQL Tutorial].dbo.EmployeeSalary order by EmployeeID --case statement select firstname, lastname, Age, (Case when Age = 38 then 'stanley' whe..
Create a table and Insert int - SQL code (Open)
Create Table EmployeeDemographics (EmployeeID int, FirstName varchar(50), LastName varchar(50), Age int, Gender varchar(50) ) Create Table EmployeeSalary (EmployeeID int, JobTitle varchar(50), Salary int ) Table 3 Query: Create Table WarehouseEmployeeDemographics (EmployeeID int, FirstName varchar(50), LastName varchar(50), Age int, Gender varchar(50) ) Insert into EmployeeDemographics VALUES (1..
