خرید بک لینک

Vote count: 0

Hello am trying to get the whole record information based on a max value for example lets say that i have this table called animals

 id         name         price
____       ______       _______
 1         dog          250
 2         cat          100
 3         bird         50

the max price is 250 then I want to retrieve its record so I should get

id         name       price
____       ____       _____
 1          dog        250

here is the query that I wrote but I know its wrong

  Select * FROM animals where price = MAX(price); 

asked 1 min ago

برچسب: نویسنده: استخدام کار تاريخ: شنبه 8 خرداد 1395 ساعت: 6:09

صفحه بندی