Set Max Result In Sql Query. Query result set too large 12487. SQL HOME SQL Intro SQL Syntax SQL Select SQL Select Distinct SQL Where SQL And Or Not SQL Order By SQL Insert Into SQL Null Values SQL Update SQL Delete SQL Select Top SQL Min and Max SQL Count Avg Sum SQL Like SQL Wildcards SQL In SQL Between SQL Aliases SQL Joins SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL.
The MAX function comes in handy in many cases such as finding the greatest number the most expensive product and the largest payment from customers. Here is the basic syntax of the MAX function. The SQL ORDER BY clause is used to sort the data in ascending or descending order based on one or more columns.
Some databases sort the query results in an ascending order by default.
Unlike the SUM COUNT and AVG functions the DISTINCT option is not applicable to the MAX function. The cached results are automatically invalidated when the underlying query data change. Video Tutorial on MAX query. Result of SQL Fetch is over the maximum result size specified for the application server.