× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Use the GROUP BY and HAVING clauses.

Something like

 SELECT fclrid, frecno FROM Ypexfile WHERE fclass = '7C' and frecid = 'H'
GROUP BY (fclrid,frecno) HAVING count(*) > 1

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


|---------+--------------------------------->
|         |           "Muralidhar Narayana" |
|         |           <Muralidhar_Narayana@i|
|         |           nfosys.com>           |
|         |           Sent by:              |
|         |           midrange-l-bounces@mid|
|         |           range.com             |
|         |                                 |
|         |                                 |
|         |           11/16/2004 03:18 PM   |
|         |           Please respond to     |
|         |           Midrange Systems      |
|         |           Technical Discussion  |
|---------+--------------------------------->
  
>------------------------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                                 |
  |       To:       <midrange-l@xxxxxxxxxxxx>                                   
                                                 |
  |       cc:                                                                   
                                                 |
  |       Subject:  Sql question                                                
                                                 |
  
>------------------------------------------------------------------------------------------------------------------------------|




Iam just doing below query, but got whole bunch of records, I basically
want to find duplicate records.

SELECT FCLRID, FRECNO FROM YPEXFILE  WHERE  FCLASS= '7C' and FRECID =

'H' ORDER BY FCLRID

Any duplicate records with respect to FRECNO(I mean i want to find if
FRECNO is same for more than one record)..

Can someone give me pointer...

Thanks,






--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.






As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.