
January 24th, 2013, 07:27 AM
|
Registered User
|
|
Join Date: Jan 2013
Posts: 1
Time spent in forums: 6 m 11 sec
Reputation Power: 0
|
|
Sql
SELECT DISTINCT DNAME,
LENGTH(DNAME) as "Max Length"
FROM DEPT
WHERE LENGTH(DNAME)=
(SELECT MAX(LENGTH(DNAME)) FROM DEPT
)
Try this n tell me...
Regards,
Vignesh L
|