select statement help

[ckmoied]

Hi all,

Just a newbie to SQL

on the categories column, I want to run a select statment that shows me all the categories in the column. Any clue please.

[ck9663]

Hi all,

Just a newbie to SQL

on the categories column, I want to run a select statment that shows me all the categories in the column. Any clue please.

could you be a little more specific?

[Shashi Sadasivan]

Hi all,

Just a newbie to SQL

on the categories column, I want to run a select statment that shows me all the categories in the column. Any clue please.

Select categories from yourTable

Is that all you are looking for?

[jwilliamsoh]

Not sure exactly what you are asking. If you want to see the value of a field called 'Category' for every record in the table you would do this:


SELECT Category
FROM YourTableNameHere

If you only want to see the unique Category values (Lets say there are three records in your table and for the Category field each have the same value of 'Customer' then my quesry above would list Customer three times, each record has the same value. If you only want to see this value one time you would do the following:

SELECT DISTINCT Category
FROM YourTableNameHere

Does this answer your question?

If you want to select the Category field but only display records that have a (AS AN EXAMPLE) ContactClass (You probably don't have this field but you will get the idea) of 'Customer' then you would write:

SELECT Category
FROM YourTableNameHere
WHERE ContactClass = 'Customer'

You would change out ContactClass with any field you want to filter by and then = 'Whatever Value you Want to Filter'

On the Select line you can add the distinct clause to not repeat a Category value.

[ckmoied]

Sorry guys for a bit confusion. I didn't explain my question well.

Select Distinct solved my problem.

thank you all.