Selecting top3 from a table [closed]

It'开发者_JAVA百科s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

How to select top3 values from a table. Please let me know the query for selecting top 3 values of the table. Thank you.

---

SELECT * FROM table ORDER BY value DESC LIMIT 3

---

SELECT TOP 3 * FROM Table

Do you need the top 3 values based on some criterion?

---

SELECT TOP 3 * From table where col = value