Wednesday 1 October 2014

second Highest value get database

SELECT totalprice FROM raw_arrivepurchase WHERE totalprice = (SELECT MAX(totalprice) FROM raw_arrivepurchase WHERE totalprice < (SELECT MAX(totalprice) FROM raw_arrivepurchase))

No comments:

Post a Comment