Keywords like TOP, LIMIT, ROWNUM, etc are database dependent. Please read this article for more information. http://en.wikipedia.org/wiki/Select_(SQL)#Result_limits
SQL Tutorial SELECT Statement — Extended Query Capabilities This subsection details the remaining features of SELECT statements. The basics are …
The SQL HAVING syntax The general syntax is: SELECT column-names FROM table-name WHERE condition GROUP BY column-names HAVING condition
I have a following data in a table: id name alarmId alarmUnit alarmLevel 1 test voltage psu warning 2 test voltage psu ceasing 3 test voltage psu warn
The SQL HAVING clause is used to do exactly this, to specify a condition for an aggregate function which is used in your query:
SQL Tutorial Table of Contents. SQL Tutorial This chapter explains what SQL (Structured Query Language) is, and where and how it is used. SQL Table
The GROUP BY clause groups records into summary rows. GROUP BY returns one records for each group. GROUP BY typically also involves aggregates: COUNT, MAX…
How to use sql group functions, How to work with sql group functions – DISTINCT, MIN, MAX, AVG, COUNT, SUM.