Using Values from Tables

Get the Rows That Contain A Specific Column Value

Let's say you have this table:

Customer ID
Customer Age
Customer Name

00001

24

David Smith

00002

68

Gertrude Williams

00003

24

Christine Urig

And you want to get ONLY the rows that contain a customer that is 24 years old. You would write:

get the rows whose "Customer Age" is "24"

This would return the following:

Customer ID
Customer Age
Customer Name

00001

24

David Smith

00003

24

Christine Urig

Last updated

Was this helpful?