Posted by Ramya on 12/30/05 13:38

If the table has a column named "age" with repeated values, then

SELECT distict age FROM <table name>

IF you need to include any condition, use as below.

SELECT distinct age FROM <table name> WHERE <condition>

[Back to original message]