Require help in Writing Query
Posted
by harigm
on Stack Overflow
See other posts from Stack Overflow
or by harigm
Published on 2010-04-02T06:14:33Z
Indexed on
2010/04/02
6:23 UTC
Read the original article
Hit count: 380
The following image have been uploaded to show what I am trying to do and what I wanted out of it
Can any one help me write the Query to get the results what I want Please check the following
SELECT *
FROM KPT
WHERE PROPERTY_ID IN (SELECT PROPERTY_ID
FROM khata_header
WHERE DIV_ID = 3
and RECORD_STATUS = 0)
and CHALLAN_NO > 42646
The above is the query I have written and I have got the following result set
ID CHALLAN_NO PROPERTY_ID SITE_NO TOTAL_AMOUNT
----- ------------- -------------- ------------------- ---------------
1242 42757 3103010141 296 595
1243 63743 3204190257 483 594
1244 63743 3204190257 483 594
1334 43395 3217010223 1088 576
1421 524210 3320050416 (null) (null)
1422 524210 3320050416 (null) (null)
1560 564355 3320021408 (null) (null)
1870 516292 3320040420 (null) (null)
1940 68357 3217100104 139 1153
1941 68357 3217100104 139 1153
2002 56256 3320100733 511 4430
2003 56256 3320100733 511 4430
2004 66488 3217040869 293 3094
2005 66488 3217040869 293 3094
2016 64571 3217040374 (null) (null)
2036 523122 3320020352 (null) (null)
2039 65682 3217040021 273 919
In my resultset, I am getting the PropertyId repeated, since there are multilple entries,
- How Can I know How many have been repeated
- What are those Property Id which have repeated more than 2 times.
Little Back ground about the tables are
- PROPERTY_ID is the FK in the KPT
- PROPERTY_ID is the PK in KH
I am writing a subquery to get the Result, so I am stuck I dont know how to get my results Please help
© Stack Overflow or respective owner
