Show List
Tutorials > SQL > Selecting and filtering data

Selecting and filtering data

SELECTing and filtering data is a common task in SQL. The SELECT statement is used to retrieve data from one or more tables in a database. Filtering data is achieved by using the WHERE clause.

Here are a few examples of SELECTing and filtering data in SQL:

  • SELECT all columns and rows from a table:

sql
Copy code
SELECT *
FROM table_name;

  • SELECT specific columns from a table:

    • sql
    Copy code
    SELECT column1, column2, column3
FROM table_name;

  • SELECT rows that meet a certain condition:

    • sql
    Copy code
    SELECT column1, column2, column3
FROM table_name
WHERE column1 = 'value';

  • SELECT rows that meet multiple conditions:

    • sql
    Copy code
    SELECT column1, column2, column3
FROM table_name
WHERE column1 = 'value1' AND column2 = 'value2';

  • SELECT rows that match a pattern:

    • sql
    Copy code
    SELECT column1, column2, column3
FROM table_name
WHERE column1 LIKE 'value%';

  • SELECT and sort data in ascending order:

    • vbnet
    Copy code
    SELECT column1, column2, column3
FROM table_name
ORDER BY column1;

  • SELECT and sort data in descending order:

    • sql
    Copy code
    SELECT column1, column2, column3
FROM table_name
ORDER BY column1 DESC;

    These are just a few examples of SELECTing and filtering data in SQL. The specific syntax and keywords used may vary depending on the database management system being used.



    Next: Sorting and grouping data

        Leave a Comment

    • captcha text