javascript - MySQL, Selecting the index based on MIN timestamp -

-

i trying index of row maximum timestamp. however, can't seem index. here's code:

client.query('select inde, min( stamp ) archive', function(err, result){         console.log(result); });

'stamp' timestamp column. above code return 1 index , timestamp. but, when switch min max, printed timestamp change max index remains same (it returns minimum index).

you're getting asked for. inde fields table, along overall global mininum records in table.

to record(s) associated minimum value, need more complicated query:

select * archive stamp = (select min(stamp) archive)

Comments

Post a Comment

Popular posts from this blog

pentaho - Carte Status / Kettle Slave Server Status page shows status for random runs instead of the latest run -

-
i trying programmatically details of specific execution of transformation what have tried far i status of kettle slave server/carte @ http://localhost:8282/kettle/status/ from page, can click on desired transformation , taken page shows details , has link xml output current status of specific execution of transformation. link this: http://localhost:8282/kettle/transstatus/?name=trans_name&id=carte_ob_id&xml=y the problem i have transformation has been run multiple times recently. don't have carte_obj_id specific run of transformation. so, can't provide in uri. if try following uri instead: http://localhost:8282/kettle/transstatus/?name=trans_name&xml=y then status of random execution. not latest 1 or specific one. the goal i writing .net gui have code. httpwebrequest req = (httpwebrequest)webrequest. create(@"http://localhost:8282/kettle/transstatus/? name=trans_name ...
Read more

c - sscanf() double showing zeros -

-
i'm having troubles sscanf() function read doubles. have comma separated text file this: abc,def,0.465798,0.754314 ghi,jkl,0.784613,0.135264 mno,opq,0.489614,0.745812 etc. so first line fgets() , use sscanf() 2 string , 2 double variables. fgets(buffer, 28, file); sscanf(buffer, "%4[^,],%4[^,],%lf[^,],%lf[^\n]", string1, string2, &double1, &double2); printf("%s %s %f %f\n", string1, string2, double1, double2); but output is: abc def 0.465798 0.000000 ghi jkl 0.784613 0.000000 mno opq 0.489614 0.000000 so somehow doesn't scan last float. i've tried %lf[^ \t\n\r\v\f,] , %lf still doesn't work. change "%4[^,],%4[^,],%lf[^,],%lf[^\n]" to int result; result = sscanf(buffer, "%4[^,],%4[^,],%lf,%lf", string1, string2, &double1, &double2); if (result != 4) // handle error notice & on double1 , double2 - likley typo. also strongly recommend check result 4. not checking sscanf(...
Read more