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
