I need to find out the receipt numbers using the SQL query to list the rows generated less than the one-minute time difference for the same purchase orders.
The output should be like this
Order # Receipt #
the above receipts generated for the same order # less than one-minute time difference. Please let me know how to find out using the SQL query.