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

If you have a table with column named "age" and it has repeated values.

SELECT DISTINCT age FROM <table name>

Else if you need to use any condition while fetching data,
then use the below query

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

• Next in forum: Re: Problem with query...
• Prev in forum: Re: Problem with query...
• Thread view: Re: Problem with query...

[Reply to this message]