how to create a MySQL View to select the smallest and largest Records?

i have a table contains items units details (st_items_units) like :-

as the table every item may be have only one unit or 2 unit or 3 unit or more.

i want to create 2 view :

1- to select the two smallest unit (if there is one unit for the item , repeat the only one ). as this table :

2- to select the smallest unit & the largest Unit (if there is one unit for the item , repeat the only one ). as this table :

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nisha Regil6y ago
Try using these links as reference.

https://www.mysqltutorial.org/create-sql-views-mysql.aspx/
https://www.mysqltutorial.org/mysql-window-functions/mysql-row_number-function/
0
Laxmidhar Sahoo6y ago
Hi

I am not clear for the first view of first row which
stitems_ID = 1

0
Darshan Shah6y ago
we can achive this with the help of group by keyword in query.
-1