[go: up one dir, main page]
Scribd
Upload
6 views1 page

Lec 1 SQL Practice

The document contains a series of SQL queries related to the 'Employees' table. These queries include selecting all columns, specific columns like 'firstname' and 'Salary', and concatenating 'firstname' and 'LastName' into a 'Full Name' field. The queries demonstrate different ways to retrieve and format employee data from the database.

Uploaded by

koulibalyhamam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
6 views1 page

Lec 1 SQL Practice

The document contains a series of SQL queries related to the 'Employees' table. These queries include selecting all columns, specific columns like 'firstname' and 'Salary', and concatenating 'firstname' and 'LastName' into a 'Full Name' field. The queries demonstrate different ways to retrieve and format employee data from the database.

Uploaded by

koulibalyhamam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

select * from Employees

select firstname from Employees

select firstname,Salary from Employees

select FirstName,LastName from Employees

select EmployeeID,concat(firstname,' ',LastName) from Employees

select EmployeeID,concat(firstname,' ',LastName) [Full Name] from Employees

select EmployeeID,concat(firstname,' ',LastName) as [Full Name] from Employees

You might also like