SQL For Data Analysis > SQL Selection Commands Ordering & Filtering

Filtering Data using Selection Command

19.4k

The process of selecting a smaller subset of your data set for viewing or analysis is known as data filtering. Filtering is usually (but not always) temporary; the entire data set is saved, but just a portion of it is used in the calculation.

Filter a set of information:

  • Within the range, select any cell.
  • Select Data > Filter from the drop-down menu.
  • Select the arrow next to the column heading.
  • Select Text Filters or Number Filters, and then a comparison, such as Between, from the drop-down menu.
  • Select OK after entering the filter criteria.

To use the Advanced Filter, follow these steps:

  • In the data table, select a cell.
  • Click Advanced in the Sort & Filter group on the Data tab of the Ribbon.
  • Select Filter the list in-place for Action.
  • Select the data table for the List range.
  • Select C1:C2 – the criteria header and formula cells – for the Criteria range.
  • To see the results, click OK.

To apply a filter to the value of a cell, type:

  • Select a cell that contains the value you wish to filter for by right-clicking it.
  • Select Filter > Filter by Value of Selected Cell.
  • The column will be subjected to the filter.

If you wish to bring back the filter menus with your keyboard, click CTRL + shift + L, and those filter buttons will appear on your top row. If you arrow over to a cell with a filter button, you can bring up the filter menu by pressing ALT + down arrow.

Learner's Ratings

3.9

Overall Rating

  • 50%
  • 18%
  • 9%
  • 18%
  • 5%

Reviews

S
Swati Patil
5

Excellent

A
Avinash Rawat
4

I want to assignment answer and data. excellent teach rawatavinash1995@gmail.com

P
Pravin Kashid
5

excellent teaching technique...one of the best course content...

R
Rahul Jadhav
4

hjygtfrhthjkl;

S
Shivam pandey
5

Thankyou sir

D
Dipayan Dutta
5

Excellent Session.

S
SHIKHAR
5

Awesome content

P
Prabhat Yadav
5

Superb course content and easy to understand.

D
Dhrubajyoti Chatterjee
4

Very good to learn.

N
Namdev Gurme
5

I learn everything here, Thanks to LearnVern

Show More
Recommended Courses
Course Content

  1. Getting Started
    18m 54s

  1. SQL Datatypes
    10m 5s
  2. SQL Commands
    21m 59s
  3. What is DBMS
    27m 51s
  4. What is RDBMS
    5m 23s

  1. Database Relationships
    11m 35s
  2. Primary Key
    6m 50s
  3. Unique Key
    3m 34s
  4. Foreign Key
    4m 2s
  5. Difference between PK, UK and PK & FK
    6m 6s

  1. SQL Server Installation Step by Step
    8m 2s

  1. How to Create Database in SQL Server
    13m 2s
  2. Assignment : SQL Create Table
    5m 5s

  1. SQL Constraints
    29m 1s
  2. SQL Insert Statement and SQL Alias
    28m 12s

  1. Filtering Data using Selection Command
    31m 53s
  2. Filtering Data using Comparison Operator
    28m 52s
  3. SQL Order by Clause
    25m 56s
  4. Assignment : Ordering and Filtering
    26m 58s

  1. Aggregate Functions in SQL for Data Analysis
    22m 31s
  2. SQL Mathematical Functions for Data Analysis
    21m 31s
  3. SQL String Functions for Data Analysis
    15m 51s
  4. SQL Date & Time Functions for Data Analysis
    17m 20s
  5. SQL Window Functions for Data Analysis
    23m 34s
  6. SQL Miscellaneous Functions
    20m 10s
  7. SQL Functions for Data Analytics - 1
    38m 28s
  8. SQL Functions for Data Analytics - 2
    40m 5s
  9. Rollup and NTile Function
    26m 36s
  10. Row Number Function
    8m 3s
  11. DenseRank and Cumulative Distribution
    29m 12s
  12. How to use SQL Conditional Statements
    4m 22s
  13. How to use SQL Group by Clause
    4m 55s
  14. SQL Practical with Examples
    49m 46s
  15. Assignment : SQL Date and Time
    15m 16s

  1. Type of Joins in SQL - INNER, LEFT
    21m 24s
  2. Type of Joins in SQL - RIGHT,SELF,FULL, CARTESIAN
    15m 14s
  3. SQL Joins Practical Session 1
    22m 17s
  4. SQL Joins Practical Session 2
    23m 29s
  5. SQL Joins Practical Session 3
    27m 43s
  6. SQL Joins Practical Session 4
    22m 26s
  7. SQL Joins Practical Session 5
    29m 41s
  8. Assignment : SQL Joins
    15m 5s
  9. Assignment : SQL Functions 1
    13m 25s
  10. Assignment : SQL Functions 2
    9m 25s

  1. Practice: SQL Subqueries
    26m 41s
  2. Practice: SQL Subqueries & Unions
    22m 29s
  3. SQL Correlated Subqueries Part 1
    20m 21s
  4. SQL Correlated Subqueries Part 2
    30m 51s
  5. SQL Correlated Subqueries Part 3
    30m 45s
  6. SQL Correlated Subqueries Part 4
    25m 7s
  7. SQL Correlated Subqueries Part 5
    19m 42s
  8. Correlated Select, Update & Delete Queries
    33m 15s
  9. SQL Union
    18m 3s
  10. SQL EXCEPT & INTERSECT
    14m 33s
  11. Assignment : SQL SubQueries
    30m 7s

  1. SQL Pivot, UnPivot Practical Example - 1
    37m 28s
  2. SQL Pivot, UnPivot Practical Example - 2
    27m 40s

  1. What are Views?
    22m 19s
  2. Examples of SQL Views Part -1
    16m 41s
  3. Examples of SQL Views Part -2
    17m 47s
  4. Assignment : SQL Views
    10m 17s

  1. What is SQL Index?
    13m 29s
  2. SQL Index types
    24m 50s

  1. Create Tables using Select Statement
    41m 2s
  2. Using Correlated Sub Query, Group By with Select Statement
    40m 2s
  3. Using Group By and Having Clauses with Select Statement
    23m 32s
  4. Using Index Optimizer with Select Statement
    23m 24s
  5. Using Union with Select Statement
    35m 4s
  6. Adding Multiple Records with Insert Statement
    22m 42s
  7. SQL Insert - Considerations and Best Practices
    9m 19s
  8. Insertion from Multiple Tables
    22m 11s
  9. SQL Delete - Types of Delete Operation Part -1
    16m 41s
  10. SQL Delete - Types of Delete Operation Part -2
    11m 38s
  11. Assignment : SQL Insert, Update & Delete
    7m 24s

  1. Loading & Connecting Different Files in SQL
    11m 18s

  1. Course Summary
    9m 6s

  1. Interview Questions Part 1
    22m 2s
  2. Interview Questions Part 2
    20m 56s

  1. Career Guideline
    2m
Enroll For Free