Delete the sections related to FIRSTVALUE & LASTVALUE - Fixes
@@ -119,30 +119,6 @@ Calculate the number of players in every city:
SELECT city_id, COUNT(*) FROM Players GROUP BY city_id;
----
-== FIRSTVALUE
-
-[source, sql]
-----
-FIRSTVALUE ([DISTINCT] <expression1>, <expression2>)
-----
-
-Returns the value of `expression1` associated with the smallest value of `expression2` for each group defined by the `group by` expression in the query.
-This function can only be used with colocated data and you have to use the `collocated` flag when executing the query.
-
-The colocated hint can be set as follows:
-
-* `SqlFieldsQuery.collocated = true` if you use the link:SQL/sql-api[SQL API] to execute queries.
-* link:SQL/JDBC/jdbc-driver#parameters[JDBC connection string parameter]
-* link:SQL/ODBC/connection-string-dsn#supported-arguments[ODBC connection string argument]
-
-
-=== Example
-The example returns
-[source, sql]
-----
-select company_id, firstvalue(name, age) as youngest from person group by company_id;
-----
-
== GROUP_CONCAT
[source,sql]
@@ -175,31 +151,6 @@ SELECT GROUP_CONCAT(name ORDER BY id SEPARATOR ', ') FROM Players;
----
-== LASTVALUE
-
-[source, sql]
-----
-LASTVALUE ([DISTINCT] <expression1>, <expression2>)
-----
-
-Returns the value of `expression1` associated with the largest value of `expression2` for each group defined by the `group by` expression.
-This function can only be used with colocated data and you have to use the `collocated` flag when executing the query.
-
-The colocated hint can be set as follows:
-
-* `SqlFieldsQuery.collocated = true` if you use the link:SQL/sql-api[SQL API] to execute queries.
-* link:SQL/JDBC/jdbc-driver#parameters[JDBC connection string parameter]
-* link:SQL/ODBC/connection-string-dsn#supported-arguments[ODBC connection string argument]
-
-=== Example
-
-[source, sql]
-----
-select company_id, lastvalue(name, age) as oldest from person group by company_id;
-----
-
-
-
== MAX
[source,sql]
