SQL Query / Function

Question

BundleID | ProductID| OrderNum
--------------------------------
1        | 1        | 1
1        | 2        | 2
2        | 1        | 1
2        | 2        | 2

Query Code :

SELECT COUNT(*) FROM table WHERE table.bundle_id = 2;

What I would like to do here is to add a new record (BundleID, ProductID, OrderNum), Where both BundleID & ProductID are pre-determined while the OrderNum will be the count + 1 (This is a music play list and I'm wondering if this is the best way to do it).

I've tried to figure out functions in postgres but I've got no progress with it.

Are they any tutorial which is easy to understad?

juergen d · Accepted Answer · 2013-09-05 12:59:54Z

1

I chose 2 as given BindleID and ProductID

insert into your_table (BundleID, ProductID, OrderNum)
SELECT BundleID , ProductID , max(OrderNum) + 1 
from your_table 
where BundleID = 2 
and ProductID = 2

answered Sep 5, 2013 at 12:59

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Query / Function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related