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.
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 following query:
select unique
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 above query must