sql - MYSQL - get lowest bid from table group by product (results weird) -


ok, baffled going on query trying following: lowest bid grouped product_id , load in product information related bid.

currently when running below query says me bid_id column product_id = 2 30 definetly not 30, should 120 (although bid_price value correct @ 29.99): 

select lowbid.bid_id, lowbid.bid_price (select bid_id, min(bid_price) bid_price, product_id tbl_products_bid is_active = 1 , is_deleted = 0 group product_id) lowbid;

now due query giving me random bid_id's, not sure why wondering if sql guru provide me insight 1. if being totally thick or 2. if there way or why getting random bid_id not related bid_price.

i have created sqlfiddle can explain mean grateful.

http://sqlfiddle.com/#!2/de77b/14

also let know query part of query took out element think giving me issue (i.e above) part of bigger query below:

select lowestbid.bid_id, lowestbid.product_id, lowestbid.bid_price seller_bid_price, seller_description, pb.is_countdown, pb.startdate, pb.enddate   tbl_products_bid pb   inner join (     select bid_id, product_id, min(bid_price) bid_price, seller_id, description seller_description, is_countdown, startdate, enddate tbl_products_bid is_active = 1 group product_id   ) lowestbid on pb.bid_id = lowestbid.bid_id order lowestbid.bid_price asc 

select  a.*    tbl_products_bid         inner join         (             select  product_id, min(bid_price) min_price                tbl_products_bid             group   product_id         ) b on  a.product_id = b.product_id ,                 a.bid_price = b.min_price

Comments

Post a Comment

Popular posts from this blog

c# - DetailsView in ASP.Net - How to add another column on the side/add a control in each row? -

i have detailsview control on page used edit various fields of record, works in respect. i looking way add 1 column (and if works, why not more) right, absolutely read-only, show same fields of record comparison purposes. i aware there no obvious way such thing out of box detailsview . have looked other controls (transposed gridview , recommended formview , listview ), nothing satisfies. have special data binding setup using detailsview , can't out of without losing features. anyone on how "hack in" additional columns (for display only) on detailsview ? the solution have now, use second detailsview , visible set false in aspx. in code, make sure databind hidden detailsview hosts data third column first, initial detailsview named itemdetails . and in item created event, pass third column html rendering of hidden controls (in last code block) : protected void itemdetails_itemcreated(object sender, eventargs e) { if (dataite
Read more

javascript - firefox memory leak -

i have following script (i use raphaeljs also) draws circle, waits 1 second, draws circle again, etc (you can copy paste - functional, need include raphael raphaeljs.com): <div id="holder"> </div> <script src="raphael.js" type="text/javascript"></script> <script> var paper = raphael(10, 50, 320, 200); var rad = math.pi / 180; var finangle = 0; function sector(cx, cy, r, startangle, endangle, params) { var x1 = cx + r * math.cos(-startangle * rad), x2 = cx + r * math.cos(-endangle * rad), y1 = cy + r * math.sin(-startangle * rad), y2 = cy + r * math.sin(-endangle * rad); return ["m", cx, cy, "l", x1, y1, "a", r, r, 0, +(endangle - startangle > 180), 0, x2, y2]; } var path = sector(100,100,50,0,180); var arc = paper.path(path); function draw() { path = sector(100,100,50,0,finangle);
Read more

Trying to import CSV file to a SQL Server database using asp.net and c# - can't find what I'm missing -

i student , quite new programming, , given task using asp.net , c#, without being taught either. plan learn teach ourselves. the task stuck on making website import csv file sql server database of last year's room bookings around campus. the table has following columns: request_id; priority; module_id; day; start_time; length; park; students; room_code; status; semester_id; linked_request; week_1; week_2; week_3; week_4; week_5; week_6; week_7; week_8; week_9; week_10; week_11; week_12; week_13; week_14; week_15; ) in code, try make work 3 columns (request_id,priority,module) starters. when press import button, want read .csv file (with fixed name @ fixed directory) eg "1,2,3" - comma separating fields [delimiter] - , import sql server datab
Read more