Obtaining the max.length product name from the product table

[ashdiip]

Can anyone help me building SQL for my following query:

To obtain the product_Name from the product table having the maximum length in all the products under Product table.

Table Structure is as follows:

Product_code varchar2(5)
Product_Name varchar2(35)

Thanx in advance.

[monalisag]

Hope this query helps you:
Select PRODUCTNAME from products
where LEN(PRODUCTNAME) IN (Select max(len(productname)) from products)

[monalisag]

the above query would run in sql server. for oracle

Select productname from products
where length(productname) IN (Select max(length(productname)) from products)

[ashdiip]

Thanx ! it worked as I wanted.