Scribd
Upload
9 views

Sqlcommands

sql

Uploaded by

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

Sqlcommands

sql

Uploaded by

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

SQL Query Commands

1. SELECT: Retrieves data from a 6. DELETE: Removes records from a table.


database.
```sql
```sql DELETE FROM employees
SELECT first_name, last_name WHERE last_name = 'Doe';
FROM employees; ```
```
7. ORDER BY: Sorts the results.
2. WHERE: Filters records based on a
condition. ```sql
SELECT first_name, last_name
```sql FROM employees
SELECT first_name, last_name ORDER BY last_name ASC;
FROM employees ```
WHERE department = 'Sales';
``` 8. GROUP BY: Groups rows that have the
same values.
3. AND/OR: Combines multiple conditions.
```sql
```sql SELECT department, COUNT(*)
SELECT first_name, last_name FROM employees
FROM employees GROUP BY department;
WHERE department = 'Sales' AND salary ```
> 50000;
``` 9. JOIN: Combines rows from two or more
tables based on a related column.
4. INSERT INTO: Adds new records to a
table. ```sql
SELECT employees.first_name,
```sql departments.department_name
INSERT INTO employees (first_name, FROM employees
last_name, department, salary) INNER JOIN departments ON
VALUES ('John', 'Doe', 'HR', 60000); employees.department_id = departments.id;
``` ```

5. UPDATE: Modifies existing records. 10. LIKE: Searches for a specified pattern.

```sql ```sql
UPDATE employees SELECT first_name, last_name
SET salary = 65000 FROM employees
WHERE first_name = 'John' AND WHERE first_name LIKE 'J%';
last_name = 'Doe'; ```
```

Buenavidez, Carl Arthur V. BSIT—21A INFORMATION


MANAGEMENT

You might also like