SQL Query (Random Records With Sum) Help

[dell_10]

Im try to write quesry to select random records from tables
with condition of .. Records number = 4 and the total sum of points = 45
table look like this

ID Points
1 10
2 15
3 20
4 10
5 5
6 15
7 30
8 12
9 11
10 10


Need Result To Be like for Example

ID Points
1 10
3 20
5 5
10 10
as u can see the sum of points = 45

Thanks

[dell_10]

No Ideas ????

[dell_10]

no one can help me ??

[nosepicker]

Relax. Chill. Is this what you want?

select top 1 D.id, ABC.Aid, ABC.Bid, ABC.Cid, D.points + ABC.Apoints + ABC.Bpoints + ABC.Cpoints
from YourTable D join
(select C.id Cid, AB.Aid, AB.Bid, C.points Cpoints, AB.Apoints, AB.Bpoints
from YourTable C join
(select A.id Aid, A.points Apoints, B.id Bid, B.points Bpoints
from YourTable A join YourTable B on A.id <> B.id) as AB
on C.id <> AB.Aid and C.id <> AB.Bid) as ABC
on D.id <> ABC.Aid and D.id <> ABC.Bid and D.id <> ABC.Cid
where D.points + ABC.Apoints + ABC.Bpoints + ABC.Cpoints = 45