| simple query [message #370369] |
Wed, 08 September 1999 06:43  |
deepak k
Messages: 3
Registered: September 1999
|
Junior Member |
|
|
dear gurus,
tell me answer of following query.
How to find difference between the lenths of the largest "ename" & its next largest val. Ref . emp table
e.g. if max(length("john")) - length("tom")
Thanking in advance.
|
|
|
|
| Re: simple query [message #370370 is a reply to message #370369] |
Wed, 08 September 1999 09:43  |
m a sivan
Messages: 34
Registered: July 1999
|
Member |
|
|
select max(D.X) -max(length(a.ename)) as b from emp a, ( select max(length(ename)) as X from emp) D
where length(a.ename)
though there are some more simpler Queries I could figure out this one only at this point...
try to make it simpler
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
