Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to judge the value in one fieds is only?
Message
From
17/05/2002 10:26:18
Sergey Berezniker
New York, United States
 
 
To
17/05/2002 10:23:48
Michale Chen
Shijiazhuang ZhiYuan Crop.
Shijiazhuang, China
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How to judge the value in one fieds is only?
Miscellaneous
Thread ID:
00658167
Message ID:
00658194
Views:
21
>Hello Sergey:
> I means: I want to know all the field's value is different.

Something like this
SELECT field1, CNT(*) AS dups ;
  FROM mytable ;
  HAVING dups > 0
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform