Retrieves rows whose values are less than the specified data.

 

Example:

SELECT * FROM Customer_dataflex WHERE recordnumber < 10