What is 3 forms of select?

There are three main forms of the SELECT statement:

* SELECT DISTINCT: This form of the SELECT statement is used to retrieve only unique rows from the specified table(s). Duplicate rows are eliminated from the result set.

* SELECT ALL: This form of the SELECT statement is used to retrieve all rows from the specified table(s).

* SELECT TOP: This form of the SELECT statement is used to retrieve the first N rows from the specified table(s). The value of N is specified in the TOP clause.