AVDHUT SHEDGE wrote:
>
> We want to get the Unique value from a table.
> can we use the following query:
>
> select unique(ProblemNo) from MainProblem;
>
> where MainProblem is a Table having Column ProblemNo.
>
> the contents of ProblemNo are
> 1
> 1
> 2
> 2
> 3
> 3
> 3
>
> the result of the
use distinct() instead.
- Original Message -
From: "AVDHUT SHEDGE" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 08, 2001 3:00 PM
Subject: Regarding SQL query with Unique
> We want to get the Unique value from a table.
> can we use the
We want to get the Unique value from a table.
can we use the following query:
select unique(ProblemNo) from MainProblem;
where MainProblem is a Table having Column ProblemNo.
the contents of ProblemNo are
1
1
2
2
3
3
3
the result of the above query must be :
1
2
3
Thank You.
__
