Code:
CREATE TABLE TABELA1 (
POLJE1 INTEGER,
POLJE2 VARCHAR(20),
POLJE3 INTEGER);
INSERT INTO TABELA1 VALUES (1,'aaaaa',1);
INSERT INTO TABELA1 VALUES (2,'bbbbbbbbbb',2);
INSERT INTO TABELA1 VALUES (3,'ccccccccccccccc',3);
//********
// STRLEN
//********
SELECT T1.POLJE1,
T2.DUZINA,
T1.POLJE3
FROM (SELECT POLJE1,
STRLEN(POLJE2) AS DUZINA,
POLJE3
FROM TABELA1) T1,
(SELECT MAX(STRLEN(POLJE2)) AS DUZINA
FROM TABELA1) T2
WHERE T1.DUZINA = T2.DUZINA
//************
// CHAR_LENGTH
//************
SELECT T1.POLJE1,
T2.DUZINA,
T1.POLJE3
FROM (SELECT POLJE1,
CHAR_LENGTH(POLJE2) AS DUZINA,
POLJE3
FROM TABELA1) T1,
(SELECT MAX(CHAR_LENGTH(POLJE2)) AS DUZINA
FROM TABELA1) T2
WHERE T1.DUZINA = T2.DUZINA
Mali primer na brzinu, probaj, trebalo bi da radi.
Someone's sitting in the shade today because someone planted a tree a long time ago.