Problem with aggregate functions

[Marek Kotowski]

I have a table PUPILS with a field Name (varchar).
The problem: how to select a longest Name in the table
and its length? I mean something like this:

SELECT Name, (MAX(LENGTH(Name))...

It doesn't work, of course. I tried 'grouping by' but this also fails.

Thank you in advance.

Marek Kotowski
Warsaw

[RP]

"Marek Kotowski" <Ma************@wsip.com.pl> schreef in bericht
news:e5*************************@posting.google.co m...

I have a table PUPILS with a field Name (varchar).
The problem: how to select a longest Name in the table
and its length? I mean something like this:

SELECT Name, (MAX(LENGTH(Name))...

It doesn't work, of course. I tried 'grouping by' but this also fails.

Thank you in advance.

Marek Kotowski
Warsaw

select name, length(name) as L
from table
order by L desc
limit 1;

(?)

RP

[RP]

"Marek Kotowski" <Ma************@wsip.com.pl> schreef in bericht
news:e5*************************@posting.google.co m...

I have a table PUPILS with a field Name (varchar).
The problem: how to select a longest Name in the table
and its length? I mean something like this:

SELECT Name, (MAX(LENGTH(Name))...

It doesn't work, of course. I tried 'grouping by' but this also fails.

Thank you in advance.

Marek Kotowski
Warsaw

select name, length(name) as L
from table
order by L desc
limit 1;

(?)

RP

[RP]

"Marek Kotowski" <Ma************@wsip.com.pl> schreef in bericht
news:e5*************************@posting.google.co m...

I have a table PUPILS with a field Name (varchar).
The problem: how to select a longest Name in the table
and its length? I mean something like this:

SELECT Name, (MAX(LENGTH(Name))...

It doesn't work, of course. I tried 'grouping by' but this also fails.

Thank you in advance.

Marek Kotowski
Warsaw

select name, length(name) as L
from table
order by L desc
limit 1;

(?)

RP