To get the minimum number of rows from a tabel based on the desired sum value in another column.

See more:

SQL

Sample tabel T0

Sno ID LOT_ID ITEM_NUM
14 1 abc123 2
18 2 abc123 5
20 3 abc123 3
22 4 abc123 4
23 5 abc123 8
15 1 xyz456 4
16 1 pqr234 8
17 1 lmn333 4
21 2 lmn333 8
19 3 lmn333 4

Let Suppose X = 7 (Total number of Items required for specified LOT = abc123)
Desired Output :

Sno ID LOT_ID ITEM_NUM
14 1 abc123 2
18 2 abc123 5

*Note: Atleast one should be containing max of item within the selected transaction