Regarding SQL query with Unique

2001-05-08 Thread AVDHUT SHEDGE 

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.


_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Regarding SQL query with Unique

2001-05-08 Thread Welcome 

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(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.
 
 
 _
 Chat with your friends as soon as they come online. Get Rediff Bol at
 http://bol.rediff.com
 
 
 
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail
 [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Regarding SQL query with Unique

2001-05-08 Thread Joseph Bueno 

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 be :
 1
 2
 3
 
 Thank You.

Hi,
The answer is in the manual ;)

http://www.mysql.com/doc/S/E/SELECT.html


Regards
--
Joseph Bueno
NetClub/Trader.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php