SQL FIRST

FIRST SQL function returns the first value of the selected column.

FIRST SQL syntax:

SELECT FIRST(column) FROM table

Ejemplo SQL FIRST:

FIRST SQL example:

idorderclientprice
1p1HARRY100
2p2CLARK300
3p3SMITH250
4p4BROWN490
5p5WHITE60
SELECT FIRST(price) FROM orders

Return the value 100, which is the value of the columan 'price' in the first row of the table.