Records SKUID Location TruckROute PickWave Qty TransDate Click to Add 1133841620

Question

Records SKUID Location TruckROute PickWave Qty TransDate Click to Add 1133841620 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 20140311 2 133841620 SFO101B 1 262287 12 162029 1162029 1162029 1162029 1 162029 1 162029 1 162029 6 162029 12 162029 12 162029 12 162029 12 162029 4 162029 1 162029 1 162029 1162029 1162029 3 136092247 SF13G3C 4130001132 SFO1P1A 675 s 136691251 SFO2MIA 675 6136691251 SFO2M1A 675 7 136691251 SFO2M1A 8 136691251 SFO2M1A 675 9136691251 SFO2M1A 675 10 133671263 SFO8C1F 11 130101796 SFO3S18 12 130101796 SFO351B 13 130101796 SFO3518 14 130101796 SFO3S18 15 137691887 SFO3X1A 16 137742770 SFO7S2C 17 137421322 SF0401C 18 137421322 SFO4D1C 675 19 133061496 SFO1F1C 20 138001656 SFOSU1A 21 130452154 SFO3X1C 22 130452154 SFO3X1C 23 130452154SFO3X1c 24 133892721 SFO7D1E 675 25 133892721 SFO7D1E 26 132781219 SFO403E 675 27135671403 SF11Q1F 28 135671403 SF1101F 29 135671403 SF1101F 30 135671403 SF1101F 31135671403SF1101F 32 130091378 SFOSS3E 33 130091378 SFOSS3E 1162029 1 162029 1 162029 2 162029 2 162029 1162029 12 162029 12 162029 12 162029 12 162029 1 162029 1 162029 12 Record. . 1 of 379738 : , Nn Filter Search

Explanation / Answer

For the given problem casepick table is used. Assuming TransDate is column capturing picked date of each SKU.

Aggregate function MAX() is used with GROUP BY clause of SKUID. Order By is used to show the result in ascending order of SKUID.

Query

SELECT SKUID, MAX(TransDate)

FROM Casepicks

GROUP BY SKUID

ORDER BY SKUID ASC;

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.