sql - Select top record from group -

-

how table

name  code abc     code1 def     code1 ghi     code2 jkl     code2 omn     code3

get result:

name  code abc   code1 ghi   code2 omn   code3

is there simple solution?

i considered want results alphabetical.

select          min(name), code           mytable  group           code

Comments

Post a Comment

Popular posts from this blog

drupal - using views argument in the view tpl.php file -

-
i newby drupal. here problem: on main page.tpl.php have code lines: "if ( $is_front == true ) { print views_embed_view('all_product_by_type_thin', "default", "canon"); print views_embed_view('all_product_by_type_thin', "default", "nikon"); }" as can see, in case of front page print "all_product_by_type_thin" view while sending parameter "cannon" , "nikon" the result of all_product_by_type_thin view altered inside views-view-unformatted--all_product_by_type_thin.tpl.php file. in file wrapping view results in kind of divs. need though, , cant figure out way it, argument sent view "canon" or "nikon" inside php code of views-view-unformatted--all_product_by_type_thin.tpl.php idea ? inside views theme file ie. views-view-unformatted--all_product_by_type_thin.tpl.php should have access $view object. one of attributes of object contain arguments pass...
Read more

silverlight - Applying a style to ItemContainerStyle in C# -

-
when i'm applying style listbox.itemcontainerstyle in c# isn't making change @ runtime. i'm using; mylistbox.itemcontainerstyle = (style)(app.current.resources["newitemstyle"]); however other styles being supplied, such buttons etc i'm going mybutton.style = (style)(app.current.resources["mymainbuttonstyle"]); i don't errors either, nothing , reverts default system style. i using app.current.resources instead of resources because "newitemstyle" wasn't defined in whole application. mistake.
Read more

php - Posting PHPBB Forum Thread/Post info in a website -

-
i trying extract, say, latest/most recent 5 threads in x section of forums , have 'posted' on website link viewers can go directly thread instead of having browse forum or not. i've seen , read tutorials online but...in honesty, phpbb seems mess me. all appreciated g.campos if don't have access forum' db, might want try phpbb3 portal, such this one . however, if have access mysql(?) db, might want give shot select sentence, such as: select * phpbb_posts forum_id = x order post_time desc limit y"; change 'x' forum id want dump from, , 'y' post_time limit want stop dumping; having in mind facing strtotime times, such 1290886590 . then, execute query , fetch result ( mysql_fetch_array ) formatting on table or whatever want. play post_subject , other columns nice output. luck. edit: have pretty extensive tutorial on phpbb page, here . give look.
Read more