|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
July 27th, 2002, 08:46 PM
|
|||
|
|||
|
Unique rows
Hi guys
Is there a way where I can SELECT * FROM TABLE where the value of the "entryRANK" field is unique? would it be something like this: "SELECT * FROM TABLE WHERE RANK is Unique" thanks Qutaibah
|
|
#2
July 28th, 2002, 04:09 AM
|
|||
|
|||
|
Hey,
You should use a distinct on the row that you want unique and also specify the other fields seperated by a comma, like this: select distinct(myName), myAge, mySex, myBlah from myTable where 1 get the idea? 
|
|
#4
February 29th, 2004, 07:58 AM
|
|||
|
|||
what's wromg?:(
mysql> select * from a;
+---+---+ | a | b | +---+---+ | a | a | | a | a | | a | c | | b | c | | b | b | +---+---+ 5 rows in set (0.00 sec) mysql> select distinct(a),b from a; +---+---+ | a | b | +---+---+ | a | a | | a | c | | b | c | | b | b | +---+---+ 4 rows in set (0.00 sec) WHYYY!!!!???? I WANT 2 ROWS!!! a IS DISTINCT!!! HEEEELP! 
|
|
#5
February 29th, 2004, 08:05 AM
|
|||
|
|||
Try...
Table DATA +---+---+ | a | b | +---+---+ | 1 | a | | 1 | a | | 1 | c | | 2 | c | | 2 | b | +---+---+ mysql> select * FROM DATA GROUP BY a; +---+---+ | a | b | +---+---+ | 1 | a | | 2 | c | +---+---+
|
|
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > Unique rows |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
