| Author | Message | ||
     Rajin Side Hero Username: Rajin Post Number: 2547 Registered: 05-2012 Posted From: 76.29.101.83 Rating: N/A |
Sure annai number pampistha | ||
| Rajin Side Hero Username: Rajin Post Number: 2546 Registered: 05-2012 Posted From: 76.29.101.83 Rating: N/A |
Edigo annai lookandi http://www.softwareadvice.com/erp/lawson-software-brand/ | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10731 Registered: 02-2009 Posted From: 166.137.8.124 Rating: N/A |
Rajin bro Sure do u know my email id so Send ur number to that we can talk As we r in diff timezones so weekend better Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10730 Registered: 02-2009 Posted From: 166.137.8.124 Rating: N/A |
Ee Lawson Liam neeson hemiti Naaku assal samaj aita ledu Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2541 Registered: 05-2012 Posted From: 76.29.101.83 Rating: N/A |
Paisalu kavali annai retire avvatam kosam Vaati gurunche ee patlu | ||
| Rajin Side Hero Username: Rajin Post Number: 2540 Registered: 05-2012 Posted From: 76.29.101.83 Rating: N/A |
Retail and warehouse annai naaku business/functional teliyanivvaru bayya Technical side nenu that too not in lawson complete adi telisthe 2 yrs chesi retire ayipothaa  Meeru lawson aa if yes , denemma kummede kada maa apice lo naadi peon range billing Mightavallu gurunchi chepthe ekkada heart attacks plus hype anukuntaaru | ||
| Sesani Junior Artist Username: Sesani Post Number: 239 Registered: 08-2014 Posted From: 173.70.134.173 Rating: N/A |
Career world lo world tour unte.. adi nuvvu successful ga complete chesav.. u can retire  | ||
| Outlaw Side Hero Username: Outlaw Post Number: 5022 Registered: 02-2012 Posted From: 65.24.101.165 Rating: N/A |
raja lawson aa financial payment system panichesedi retail client a | ||
| Rajin Side Hero Username: Rajin Post Number: 2539 Registered: 05-2012 Posted From: 76.29.101.83 Rating: N/A |
Timepass annai Started as dotnet developer , tarvta sql , abap Tarvta sharepoint eppudu Sharepoint+Lawson ane oka kankara rod Lanti ERP So ala prayanam sagisthunna , one point of time only sql chesina rojulu vunnayi Age tho mathimarupu vachchesindhi so slowly loosing all  | ||
| Sannayi_nokkulu Junior Artist Username: Sannayi_nokkulu Post Number: 199 Registered: 06-2014 Posted From: 108.166.164.175 Rating: N/A |
mari ee 3yrs emi chesav annai | ||
| Rajin Side Hero Username: Rajin Post Number: 2536 Registered: 05-2012 Posted From: 76.29.101.83 Rating: N/A |
Thanks everyone for all responses.. you guys rock...3 years ayyindhi query raasi..malli dulapaaliii ... | ||
| Rajin Side Hero Username: Rajin Post Number: 2535 Registered: 05-2012 Posted From: 76.29.101.83 Rating: N/A |
vere scenarios kudaaa ayipoyi annai, thanks again Annai | ||
| Rajin Side Hero Username: Rajin Post Number: 2534 Registered: 05-2012 Posted From: 76.29.101.83 Rating: N/A |
thanks very much annai oka query done got the desired output ,annai emi anukokapothe mee free time lo conditions koncham expalining cheyyandi annaihhh.....elanti latkoor queries oka moodu naalugu vunayi avi raasukuntaaa....  | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10729 Registered: 02-2009 Posted From: 166.137.8.118 Rating: |
Rajin Xclude last condition block as it's not necessary Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10728 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
SELECT * FROM @tblData AS t WHERE EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = t.Promo_Cnt FETCH FIRST 1 ROWS ONLY ) AND EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(DISTINCT it.Discount) > 1 FETCH FIRST 1 ROWS ONLY ) AND EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber AND it.Discount = t.Discount GROUP BY it.GroupType,it.ItemNumber,it.Discount HAVING COUNT(1) = 1 FETCH FIRST 1 ROWS ONLY ) AND NOT EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = 1 FETCH FIRST 1 ROWS ONLY ) Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2532 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
086013 YP1 YP 3 1.32 086014 YP1 YP 3 1.32 086015 YP1 YP 3 1.32 086015 YP2 YP 3 1.32 086015 YP3 YP 3 1.32 086016 YP1 YP 3 1.32 086016 YP2 YP 3 1.32 086016 YP3 YP 3 1.32 086122 YP1 YP 3 1.32 086122 YP2 YP 3 1.22 086122 YP3 YP 3 1.32 092265 CA1 CA 1 2.59 092266 CA1 CA 1 1.32 023009 CE1 CE 3 0.80 023009 CE2 CE 3 0.80 023009 CE3 CE 3 0.80 last query meeru pampindhi run chesthe 086122 YP2 YP 3 1.22 092265 CA1 CA 1 2.59 092266 CA1 CA 1 1.32 ee mooode vachhayi... 086122 YP2 YP 3 1.22 is exception as other times( see table values above) they have 1.32 value... thats correct 092265 CA1 CA 1 2.59 092266 CA1 CA 1 1.32 evi correct kada according 4 column aa items 1 time ee ravali alage vachhayi so discount different anataaniki vere value ledu avasarm ledu so ignore cheyyalii.... same item based on the repeat value (column 4 value) repeat ayithe different discounts vunte aa item list cheyyali , ade column 1 vunte enkaa different avvadu kada so ignore | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10727 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
U r kanfusing me again Malla evi eliminate seyaali  Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2531 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
spot annai... kekaaa antheee ee 3 ee vachhayii 086122 YP2 YP 3 1.22 092265 CA1 CA 1 2.59 092266 CA1 CA 1 1.32 eppudu 092265 and 66 as these are no exceptions , occurance should be 1 and they dis once..evi 2 eliminate chesthe oka query ayipoyinatteee | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10726 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
SELECT * FROM @tblData AS t WHERE EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = t.Promo_Cnt FETCH FIRST 1 ROWS ONLY ) AND ( EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(DISTINCT it.Discount) > 1 FETCH FIRST 1 ROWS ONLY ) OR EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = 1 FETCH FIRST 1 ROWS ONLY ) ) AND EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber AND it.Discount = t.Discount GROUP BY it.GroupType,it.ItemNumber,it.Discount HAVING COUNT(1) = 1 FETCH FIRST 1 ROWS ONLY ) Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2529 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
086013 YP1 YP 3 1.32 086014 YP1 YP 3 1.32 086015 YP1 YP 3 1.32 086015 YP2 YP 3 1.32 086015 YP3 YP 3 1.32 086016 YP1 YP 3 1.32 086016 YP2 YP 3 1.32 086016 YP3 YP 3 1.32 086122 YP1 YP 3 1.32 086122 YP2 YP 3 1.22 086122 YP3 YP 3 1.32 092265 CA1 CA 1 2.59 092266 CA1 CA 1 1.32 023009 CE1 CE 3 0.80 023009 CE2 CE 3 0.80 023009 CE3 CE 3 0.80 moththam table nunchi lo 086122 YP2 YP 3 1.22 edi okkate ravali oka query other query ki 086013 YP1 YP 3 1.32 086014 YP1 YP 3 1.32 ee rende ravaali above scenarios atappa evi raakudadu | ||
| Rajin Side Hero Username: Rajin Post Number: 2528 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
yes 086122 YP1 YP 3 1.32 086122 YP2 YP 3 1.22 086122 YP3 YP 3 1.32 092265 CA1 CA 1 2.59 092266 CA1 CA 1 1.32 kaani naaku kavalisindhi edi 086122 YP2 YP 3 1.22 92265 and 92266 not exceptions kada as they are supposed to have one occurance and they dis same so different discount vunna ignore... 086122 YP1 YP 3 1.32 086122 YP3 YP 3 1.32 ee rendu same... so ignore 086122 (086122 YP2 YP 3 1.22) 3rd occurance(it should) and discount is different } | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10725 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Also all single occurrence you should get With matching count should be 1 Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10724 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Also all single occurrence you should get Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10723 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
U should get 0922265 and 0922266 as well as they both Have single occurrence Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2527 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
result ela vachhindhi 086122 YP1 YP 3 1.32 086122 YP2 YP 3 1.22 086122 YP3 YP 3 1.32 | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10722 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
SELECT * FROM @tblData AS t WHERE EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = t.Promo_Cnt FETCH FIRST 1 ROWS ONLY ) AND ( EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(DISTINCT it.Discount) > 1 FETCH FIRST 1 ROWS ONLY ) OR EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = 1 FETCH FIRST 1 ROWS ONLY ) ) TanQ to google talli Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10721 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
SELECT * FROM @tblData AS t WHERE EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = t.Promo_Cnt FETCH FIRST 1 ROWS ONLY ) AND ( EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(DISTINCT it.Discount) > 1 FETCH FIRST 1 ROWS ONLY ) OR EXISTS ( SELECT 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = 1 FETCH FIRST 1 ROWS ONLY ) ) Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2526 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
ade use chesaaaa eppude.. results vachhayi just analysing thanks annai for query enkaa nenu tweak chesukunta | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10720 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Rajin Use fetch first 1 rows only Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2524 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
annai, handsup converting cheddamanukunnaa TOP 1 1 ki alternative emiti DB2 laaa? meeku telistheee... | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10719 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Rajin Yep TOP 1 1 It's for checking existence of row based on Condition that we r checking Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Gotcha Hero Username: Gotcha Post Number: 16882 Registered: 02-2008 Posted From: 8.19.193.14 Rating: N/A |
group by cheyi simple query idi. groupby vadite aggregate functions like max vadali columns ki This Andhra real estate is for sale. | ||
| Rajin Side Hero Username: Rajin Post Number: 2519 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
annai edenti TOP1 aaa? | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10718 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Here is the correct query SELECT * FROM @tblData AS t WHERE EXISTS ( SELECT TOP 1 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = t.Promo_Cnt ) AND ( EXISTS ( SELECT TOP 1 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(DISTINCT it.Discount) > 1 ) OR EXISTS ( SELECT TOP 1 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = 1 ) ) Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10717 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Here is the query SELECT * FROM @tblData AS t WHERE EXISTS ( SELECT TOP 1 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(1) = t.Promo_Cnt ) AND EXISTS ( SELECT TOP 1 1 FROM @tblData AS it WHERE it.GroupType = t.GroupType AND it.ItemNumber = t.ItemNumber GROUP BY it.GroupType,it.ItemNumber HAVING COUNT(DISTINCT it.Discount) >= 1 ) Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2509 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
Naa table lo data below... ITEM PROMO TYPE PROMO_CNT DISCOUNT 086013 YP1 YP 3 1.32 086014 YP1 YP 3 1.32 086015 YP1 YP 3 1.32 086015 YP2 YP 3 1.32 086015 YP3 YP 3 1.32 086016 YP1 YP 3 1.32 086016 YP2 YP 3 1.32 086016 YP3 YP 3 1.32 086122 YP1 YP 3 1.32 086122 YP2 YP 3 1.22 086122 YP3 YP 3 1.32 092265 CA1 CA 1 2.59 092266 CA1 CA 1 1.32 023009 CE1 CE 3 0.80 023009 CE2 CE 3 0.80 023009 CE3 CE 3 0.80 First kavalasini query : daaniki mundu Third column value indicates GroupTYPE of the item ,4 column value indicates how many times that value should be repeated so same item number with in group with different discount kavali only this value qualifies as output(same item ki 1.32 and 1.32 vunnayi so - 086122 YP2 YP 3 1.22 is the output so ee 2 values enduku ignore chesaam ante even discount is different , they are supposed to repeated 3 times based on column 4 which says 3 kaani ala avvaledu second query output kindaa ee values kavali items which are not repeated according to the column 4 corresponsding row for the same item 086013 YP1 YP 3 1.32 086014 YP1 YP 3 1.32 for example 092265 CA1 CA 1 2.59 092266 CA1 CA 1 1.32 e items enduku correct ante they are supposed to repeat 1 time according to column 4 and they did so discounts ni kudaa consider cheyyamu... . | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10716 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Rajin bro Best is post sample raw or table data And place output how u want That makes easy for every one Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2506 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
wok avvaledu, Coconada brother ki reply echhaa akkadaa clear gaa pettanu anukuntaa adi choodandi.. aliasing lekundaa row values comparing with in table comparing avvadu anukuntaaa... | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10715 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Typo error. Count(Distinct Discount) AS [Count] Ani typing seyu Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2505 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
adi kaadu annai suppose edi choodu 086122 YP1 YP 3 1.32 086122 YP2 YP 3 1.22 086122 YP3 YP 3 1.32 023009 CE1 CE 3 0.80 023009 CE2 CE 3 0.80 023009 CE3 CE 3 0.80 3rd column indicated the group , so group same item different discount than other 2 kavali like-- 086122 YP2 YP 3 1.22 next one edi choodandi 086013 YP1 YP 3 1.32 086014 YP1 YP 3 1.32 086015 YP1 YP 3 1.32 086015 YP2 YP 3 1.32 086015 YP3 YP 3 1.32 4 th column value indicates how many times that item has to be repeated 086013 YP1 YP 3 1.32 086014 YP1 YP 3 1.32 ee 2 values one time repeat ayya evi kavali , 3 times avvali (086015 3 times ayyindhi) | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10714 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Based in ur requirement Select Item, promotype, discount , count(Diatinct Discount) AS [Count] From <table> Group by item, promotype,discount Hope this helps Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Legend Username: Twitter Post Number: 34139 Registered: 10-2009 Posted From: 198.240.130.75 Rating: N/A |
sorry =1 | ||
| Legend Username: Twitter Post Number: 34138 Registered: 10-2009 Posted From: 198.240.130.75 Rating: N/A |
and first requirement ki < 1 | ||
| Rajin Side Hero Username: Rajin Post Number: 2504 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
edaina parvaledu converting chesukuntaaa... | ||
| Rajin Side Hero Username: Rajin Post Number: 2503 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
adi table data annai naaku kavalisina queries output first one 086122 YP2 YP 3 1.22(discount is different for same item in same promotype) second one 086013 YP1 YP 3 1.32 086014 YP1 YP 3 1.32 | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10713 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Let me know r u using OraKill or MSSql Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Cocanada Legend Username: Cocanada Post Number: 47327 Registered: 01-2008 Posted From: 168.244.164.254 Rating: N/A |
group by item - count of distinct discount > 1 | ||
| Driverramudu Hero Username: Driverramudu Post Number: 10712 Registered: 02-2009 Posted From: 166.137.8.118 Rating: N/A |
Jara klear ga seppu Life is Race. I am in. Driving is my PASSION. Ayya baaboi bullet baby Dhaga... Dhaga... Champuthondi chocolate baby Sega...Sega.. | ||
| Rajin Side Hero Username: Rajin Post Number: 2502 Registered: 05-2012 Posted From: 63.250.254.2 Rating: N/A |
Edi naa Query Output/temp table result anukondi ITEM PROMO TYPE PROMO_CNT DISCOUNT 086013 YP1 YP 3 1.32 086014 YP1 YP 3 1.32 086015 YP1 YP 3 1.32 086015 YP2 YP 3 1.32 086015 YP3 YP 3 1.32 086016 YP1 YP 3 1.32 086016 YP2 YP 3 1.32 086016 YP3 YP 3 1.32 086122 YP1 YP 3 1.32 086122 YP2 YP 3 1.22 086122 YP3 YP 3 1.32 092265 CA1 CA 1 2.59 092266 CA1 CA 1 1.32 023009 CE1 CE 3 0.80 023009 CE2 CE 3 0.80 023009 CE3 CE 3 0.80 Naaku kavalalsini outputs 086122 YP2 YP 3 1.22(discount is different for same item in same promotype) and second one 086013 YP1 YP 3 1.32 086014 YP1 YP 3 1.32 veetiki Items ki promotype 3 vundaali kaani okasare vundi experts opinions please with query... |
