Highlight Current Page in Menu bar

Highlight Current Page in Menu bar

Second highest salary in mysql

Second highest salary in mysql

Seo friendly url using htaccess

Seo friendly url using htaccess

Jsp tutorials

Visite hete for the best jsp tutorials : http://freewebmentor.com/jsp-tutorial-for-beginners-with-examples.html

Best webdevelopment Tutorials

More web development Tutorials visite here http://freewebmentor.com/

MySQL select DISTINCT by highest value

SELECT 
    p.*
FROM
        product p
    INNER JOIN
        ( SELECT 
              magazine, MAX(onSale) AS latest
          FROM
              product
          GROUP BY 
              magazine
        ) AS groupedp
      ON  groupedp.magazine = p.magazine
      AND groupedp.latest = p.onSale ;