Hello,
I have a table containing manufacturing data. I need to return the top 5 rows like -
ItemNo Total
8745-DS-M 1230
55004-LFT-XL 560
8743-DS-M 520
55004-RT-XL 486
8744-FG-XS 444
That was accomplished. Now, I need to create an overview screen, a dashboard where I will use each of the rows returned individually to show graphical content.
I need to be able to pull each of th above 5 rows individually in 5 different containers on my screen. How will I reference each row individually.
8745-DS-M 55004-LFT-XL 8743-DS-M 55004-RT-XL 8744-FG-XS
1230 560 520 486 444
I only need the SQL to reference the rows individually in different containers in my screen.
Update -
The table is dynamic, so the items can be random and different everyday.
Thanks,
Mohit.