I have a table with the columns: account number, message type, delivery date
I would like to get all the rows when the message that was sent is type 0
Ex of table:
Account number. Message type. Delivery date
123. 3. 22/1/12
345. 0. 23/1/12
345. 5. 23/1/12
456. 4. 24/1/12
789. 0. 25/1/12
986. 6. 26/2/12
The result I need:
345. 0. 23/1/12
345. 5. 23/1/12
789. 0. 25/1/12
I would like to get all the rows when the message that was sent is type 0
Ex of table:
Account number. Message type. Delivery date
123. 3. 22/1/12
345. 0. 23/1/12
345. 5. 23/1/12
456. 4. 24/1/12
789. 0. 25/1/12
986. 6. 26/2/12
The result I need:
345. 0. 23/1/12
345. 5. 23/1/12
789. 0. 25/1/12