Oracle Live SQL - Script: Get the top-N rows per group (2024)

ORDER_IDORDER_DATETIMECUSTOMER_IDORDER_STATUSSTORE_IDRN
149116-JAN-19 08.12.31.926232 AM1COMPLETE11139031-DEC-18 03.47.26.170374 PM1COMPLETE1220129-APR-18 11.48.01.437203 AM1COMPLETE1318226-APR-18 03.56.02.680569 AM1COMPLETE1415920-APR-18 12.51.57.254596 PM1COMPLETE1576509-SEP-18 08.32.41.319898 AM2COMPLETE21511-FEB-18 06.01.30.906119 PM2COMPLETE12152020-JAN-19 11.42.12.885651 PM3COMPLETE1183222-SEP-18 10.12.29.878125 AM3COMPLETE3276609-SEP-18 11.33.57.269603 AM3COMPLETE1360811-AUG-18 06.57.30.697703 PM3COMPLETE1454427-JUL-18 05.27.59.314441 AM3COMPLETE1530727-MAY-18 04.27.28.810727 AM3COMPLETE1629824-MAY-18 08.30.09.072186 PM3COMPLETE176322-MAR-18 06.17.24.214468 AM3COMPLETE182001-MAR-18 10.07.32.467335 AM3COMPLETE39104-FEB-18 01.20.22.245677 PM3CANCELLED110146813-JAN-19 01.22.50.411160 AM4COMPLETE11145511-JAN-19 02.35.59.390244 PM4COMPLETE1292010-OCT-18 04.55.19.471734 AM4COMPLETE4367223-AUG-18 12.33.23.328945 PM4COMPLETE4458505-AUG-18 09.58.27.792726 PM4COMPLETE1550617-JUL-18 09.52.33.762499 PM4COMPLETE1645302-JUL-18 11.08.52.629924 PM4COMPLETE4770731-AUG-18 05.08.24.306909 AM5COMPLETE1133103-JUN-18 01.25.06.729734 PM5COMPLETE1230627-MAY-18 03.20.25.802951 AM5COMPLETE53145010-JAN-19 06.52.30.324331 PM6COMPLETE11111112-NOV-18 11.38.06.043178 PM6COMPLETE12105803-NOV-18 02.53.59.709450 PM6COMPLETE6397219-OCT-18 01.08.36.540797 PM6COMPLETE6476909-SEP-18 01.45.17.970634 PM6REFUNDED1520430-APR-18 11.39.15.779302 AM6COMPLETE16189025-MAR-19 11.31.58.636926 PM7COMPLETE71155524-JAN-19 03.17.49.859502 PM7COMPLETE72112115-NOV-18 10.21.03.765653 AM7COMPLETE1395015-OCT-18 05.58.32.401980 PM7COMPLETE1486229-SEP-18 01.30.09.602519 AM7COMPLETE75181710-MAR-19 09.54.25.125750 PM8COMPLETE81156125-JAN-19 07.56.53.190977 AM8COMPLETE82154323-JAN-19 11.49.58.042142 AM8COMPLETE13108207-NOV-18 04.25.22.587208 PM8COMPLETE8499323-OCT-18 09.12.34.064134 PM8COMPLETE1543026-JUN-18 07.51.51.514668 PM8COMPLETE1624008-MAY-18 12.27.09.346498 AM8COMPLETE1719628-APR-18 04.53.48.264575 PM8COMPLETE18126010-DEC-18 12.17.10.374740 AM9COMPLETE91110211-NOV-18 09.21.21.436253 AM9COMPLETE9296818-OCT-18 11.26.07.286451 AM9COMPLETE1392811-OCT-18 04.03.45.848273 AM9COMPLETE14

Rows 1 - 50. More rows exist.

Oracle Live SQL - Script: Get the top-N rows per group (2024)
Top Articles
Latest Posts
Article information

Author: Neely Ledner

Last Updated:

Views: 6655

Rating: 4.1 / 5 (62 voted)

Reviews: 85% of readers found this page helpful

Author information

Name: Neely Ledner

Birthday: 1998-06-09

Address: 443 Barrows Terrace, New Jodyberg, CO 57462-5329

Phone: +2433516856029

Job: Central Legal Facilitator

Hobby: Backpacking, Jogging, Magic, Driving, Macrame, Embroidery, Foraging

Introduction: My name is Neely Ledner, I am a bright, determined, beautiful, adventurous, adventurous, spotless, calm person who loves writing and wants to share my knowledge and understanding with you.