Posting Date Document No_ Buy-from Vendor No_ Name No_ No_ 2 Direct Unit Cost
9-Jun-17 I/IMP/NOD1718/0038 V00872 NINGBO INTELL PNEUMATIC TECHNOLOGY CO.,LTD TR-004233 PPCG8-02G 0.155
27-May-17 I/IMP/NOD1718/0030 V00872 NINGBO INTELL PNEUMATIC TECHNOLOGY CO.,LTD TR-004233 PPCG8-02G 0.155
28-Jan-11 I/EXP-TOH/09-10/1205 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.144
4-Jan-13 I/IMP/NOD1213/0105 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
30-Jul-13 I/IMP/NOD1314/0043 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
24-Jan-14 I/IMP/NOD1314/0112 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
3-Jul-14 I/IMP/NOD1415/0048 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
7-Feb-15 I/IMP/NOD1415/0161 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
29-Apr-15 I/IMP/NOD1516/0015 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
31-Aug-15 I/IMP/NOD1516/0071 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
4-Apr-16 I/IMP/NOD1617/0001 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
29-Nov-16 I/IMP/NOD1617/0116 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
30-Jul-12 I/IMP/NOD1213/0044 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
18-Feb-13 I/IMP/NOD1213/0116 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
28-Sep-13 I/IMP/NOD1314/0068 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
20-Feb-14 I/IMP/NOD1314/0123 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
26-Aug-14 I/IMP/NOD1415/0074 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
20-Feb-15 I/IMP/NOD1415/0168 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
29-May-15 I/IMP/NOD1516/0032 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
31-Oct-15 I/IMP/NOD1516/0101 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
19-May-16 I/IMP/NOD1617/0024 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
31-Jan-17 I/IMP/NOD1617/0149 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
18-Nov-10 I/TRD/09-10/0133 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.144
30-Jul-12 I/IMP/NOD1213/0045 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
8-May-13 I/IMP/NOD1314/0013 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
28-Sep-13 I/IMP/NOD1314/0068 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
2-May-14 I/IMP/NOD1415/0015 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
11-Oct-14 I/IMP/NOD1415/0095 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
21-Mar-15 I/IMP/NOD1415/0187 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
29-May-15 I/IMP/NOD1516/0032 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
1-Dec-15 I/IMP/NOD1516/0116 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
25-Jun-16 I/IMP/NOD1617/0044 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
21-Mar-17 I/IMP/NOD1617/0175 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
18-Nov-10 I/TRD/09-10/0134 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.144
6-Apr-11 I/EXP-OTH/11-12/0053 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.144
7-Aug-12 I/IMP/NOD1213/0050 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
30-Jul-13 I/IMP/NOD1314/0043 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
13-Nov-13 I/IMP/NOD1314/0082 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
3-Jul-14 I/IMP/NOD1415/0048 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
24-Dec-14 I/IMP/NOD1415/0135 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
24-Apr-15 I/IMP/NOD1516/0014 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
4-Jul-15 I/IMP/NOD1516/0047 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
16-Jan-16 I/IMP/NOD1516/0138 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
7-Nov-16 I/IMP/NOD1617/0108 V00115 NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) TR-004233 PPCG8-02G 0.155
CREATE TABLE mytable (
Posting_Date VARCHAR(9) NOT NULL PRIMARY KEY
,Document_No_ VARCHAR(20) NOT NULL
,Buyfrom_Vendor_No_ VARCHAR(6) NOT NULL
,NAME VARCHAR(42) NOT NULL
,No_ VARCHAR(9) NOT NULL
,No_2 VARCHAR(9) NOT NULL
,Direct_Unit_Cost NUMERIC(5, 3) NOT NULL
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'9-Jun-17'
,'I/IMP/NOD1718/0038'
,'V00872'
,'NINGBO INTELL PNEUMATIC TECHNOLOGY CO.,LTD'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'27-May-17'
,'I/IMP/NOD1718/0030'
,'V00872'
,'NINGBO INTELL PNEUMATIC TECHNOLOGY CO.,LTD'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'28-Jan-11'
,'I/EXP-TOH/09-10/1205'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.144
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'4-Jan-13'
,'I/IMP/NOD1213/0105'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'30-Jul-13'
,'I/IMP/NOD1314/0043'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'24-Jan-14'
,'I/IMP/NOD1314/0112'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'3-Jul-14'
,'I/IMP/NOD1415/0048'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'7-Feb-15'
,'I/IMP/NOD1415/0161'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'29-Apr-15'
,'I/IMP/NOD1516/0015'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'31-Aug-15'
,'I/IMP/NOD1516/0071'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'4-Apr-16'
,'I/IMP/NOD1617/0001'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'29-Nov-16'
,'I/IMP/NOD1617/0116'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'30-Jul-12'
,'I/IMP/NOD1213/0044'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'18-Feb-13'
,'I/IMP/NOD1213/0116'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'28-Sep-13'
,'I/IMP/NOD1314/0068'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'20-Feb-14'
,'I/IMP/NOD1314/0123'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'26-Aug-14'
,'I/IMP/NOD1415/0074'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'20-Feb-15'
,'I/IMP/NOD1415/0168'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'29-May-15'
,'I/IMP/NOD1516/0032'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'31-Oct-15'
,'I/IMP/NOD1516/0101'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'19-May-16'
,'I/IMP/NOD1617/0024'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'31-Jan-17'
,'I/IMP/NOD1617/0149'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'18-Nov-10'
,'I/TRD/09-10/0133'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.144
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'30-Jul-12'
,'I/IMP/NOD1213/0045'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'8-May-13'
,'I/IMP/NOD1314/0013'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'28-Sep-13'
,'I/IMP/NOD1314/0068'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'2-May-14'
,'I/IMP/NOD1415/0015'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'11-Oct-14'
,'I/IMP/NOD1415/0095'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'21-Mar-15'
,'I/IMP/NOD1415/0187'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'29-May-15'
,'I/IMP/NOD1516/0032'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'1-Dec-15'
,'I/IMP/NOD1516/0116'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'25-Jun-16'
,'I/IMP/NOD1617/0044'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'21-Mar-17'
,'I/IMP/NOD1617/0175'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'18-Nov-10'
,'I/TRD/09-10/0134'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.144
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'6-Apr-11'
,'I/EXP-OTH/11-12/0053'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.144
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'7-Aug-12'
,'I/IMP/NOD1213/0050'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'30-Jul-13'
,'I/IMP/NOD1314/0043'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'13-Nov-13'
,'I/IMP/NOD1314/0082'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'3-Jul-14'
,'I/IMP/NOD1415/0048'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'24-Dec-14'
,'I/IMP/NOD1415/0135'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'24-Apr-15'
,'I/IMP/NOD1516/0014'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'4-Jul-15'
,'I/IMP/NOD1516/0047'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'16-Jan-16'
,'I/IMP/NOD1516/0138'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
INSERT INTO mytable (
Posting_Date
,Document_No_
,Buyfrom_Vendor_No_
,NAME
,No_
,No_2
,Direct_Unit_Cost
)
VALUES (
'7-Nov-16'
,'I/IMP/NOD1617/0108'
,'V00115'
,'NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT)'
,'TR-004233'
,'PPCG8-02G'
,0.155
);
Data to be sorted as per posting date (Latest date on top – descending order)
The query should extract only one record of latest posting date from duplicate records where Buy-from Vendor No_ & No_ 2
are repeating.
Desired output
+--------------+--------------------+---------------------+--------------------------------------------+-----------+-----------+------------------+
| Posting Date | Document No_ | Buy-from Vendor No_ | Name | No_ | No_ 2 | Direct Unit Cost |
+--------------+--------------------+---------------------+--------------------------------------------+-----------+-----------+------------------+
| 9-Jun-17 | I/IMP/NOD1718/0038 | V00872 | NINGBO INTELL PNEUMATIC TECHNOLOGY CO.,LTD | TR-004233 | PPCG8-02G | 0.155 |
| 21-Mar-17 | I/IMP/NOD1617/0175 | V00115 | NINGBO ISAIAH PNEUMATICS CO LTD.(IMPORT) | TR-004233 | PPCG8-02G | 0.155 |
+--------------+--------------------+---------------------+--------------------------------------------+-----------+-----------+------------------+