SQL – How To Retrieve Data With Maximum Length?

Suppose you have a schema called mySchema and a table called myTable. You would like to retrieve all data with maximum length (for instance, whose first name is the longest).

The following is a simple query to handle situations like this.

select  * from 
where length(myTable.firstName)=  
(select max(length(myTable.firstName))  
from mySchema.myTable

Simple Huh ! Well it sometimes saves you a minute. The functions are tested to work in DB2/AS-400