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:
This would return the following:
Customer ID
Customer Age
Customer Name
00001
24
David Smith
00003
24
Christine Urig
Last updated
Was this helpful?