Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I select similar records
Message
From
23/10/1996 14:10:17
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00010792
Message ID:
00010801
Views:
30
>>
>>Probably I misunderstand you but why you could not run command:
>>SELECT * from mytable where Score=nScore
>
>scenario:
>
>rec#1 98.2
>rec#2000 98.2
>rec#300 100
>rec#4 100 etc.
>
>I'm looking for the tie here and not a particular score? And I also need to list everyone with similar scores...
>
>TIA

OK. You have to :
1. Create temp cursor with tied scores
Select score from mytable into cursor tmp having count(*)>1 group by score
2. Join two tables by score field
Select mytable.* from mytable,tmp where mytable.score=tmp.score
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform