SQLTeam.com | Weblogs | Forums

Need answer soon! Please help


#1

Query 1 – Active Homeowner Policies where the Roof is Over 17 Years Old.
My answer was : ELECT P.status, P.policyType, P.insuredID AS "POLICY INSURED ID", H.roofYearBuilt, H.policyID,H.homeownerID,
P.policyID AS "POLICY ID", InsuredLog.insuredID
FROM HomeownerDwelling H INNER JOIN Policy P
ON H.policyID = P.policyID CROSS JOIN InsuredLog
WHERE roofYearBuilt <= 1998 and policyType=4 and status=1;

**I WAND TO USE MOD OPERATION IN "WHERE CLAUSE" OR ANY OTHER CONDITION. HOW CAN I DO IT?


#2
where roofyearbuild<year(getdate())-17

Regarding mod functionality: select 9%5 results in 4


#3

This clearly sounds like homework. So I can guide you but I can't just give you a canned answer.

Why do you think you need a MOD operation for this query? Is that just a random requirement to add to the query to show you can use it or do you need one for some actual purpose?


#4

Why the use of CROSS JOIN ? I would expect a INNER JOIN ON insuredID or maybe policyID


#5

Thanks a lot . IT WORKS.