SQL Selcting Single Table Commands

Question 1

What does the command SELCET do? and can you provide and example

Answer 1

It retrieves data from a database table

Example:

SELECT name,age
FROM users

Question 2

What doesnthe command FROM do?and give an example

Answer 2

It specifies the table that we need to retrieve data from
Example:
SELECT height, gender
FROM athletes

Question 3

What dose the command WHERE do? And give and example

Answer 3

If filters the data based on a specific condition

Example:
SELECT * FROM users
WHERE age<30

Question 4

What does the command LIKE do?and give an example

Answer 4

Filters the data based on a specific pattern

Example:

SELECT * FROM users
WHERE name LIKE ‘J%’

Question 5

What does the command AND do ?
And give an example

Answer 5

Combines multiple conditions in a WHERE clause

Example:

SELECT * FROM users
WHERE age > 18 AND city = ‘New York’

Question 6

What dose the OR command do and give an example

Answer 6

Retrieves data when at least one of the conditions is true

Example:

SELECT * FROM users
WHERE age < 18 OR city = ‘New York’

Question 7

What are WILDCARDS and give an example

Answer 7

‘’ and ‘%’ symbols are used for searching and matching data
‘’ used to select all columns in a table
‘%’ used as a wildcard character in the LIKE operator

Examples :
1. SELECT * FROM users

2. SELECT * FROM users WHERE name LIKE ‘J%’