How to find minimum and maximum length name in a table with there respective size using sql

Question

You can write two queries separately

Answer 1

Yes got it. Check this once.

With Minimum length :-

Select * from (
Select top 1 Name, LEN(Name) Name_Length from Table_Name where Name IS NOT NULL AND LEN(Name) > 0 Order By Name_Length ASC, Name ASC) TblMin

With Maximum length :-

Select * from (
Select top 1 Name, LEN(Name) Name_Length from Table_Name Order By Name_Length DESC, Name DESC) TblMax

Answer 2

Top work in SQL, limit work in Oracle. I checked and verify in SQL

Edited:-

Top work in SQL, ROWNUM works in Oracle. I have checked and verify in SQL Management Studio.

Answer 3

What happened with this way?

Answer 4

Your question is not clear.

Answer 5

How to find a name in any table with maximum length (means maximum character ) and also retrieve that name from the table

Now you got it?

Answer 6

I think top keyword doesn't work in oracle

Answer 7

By the way thank you i will inform you after checking it on my pc

Answer 8

Is there any other way to find it

Answer 9

It is not working in my laptop
This query is throwing an error "windows specification is missing for this function"

Answer 10

And limit keyword doesn't work in oracle it works in mysql. I have tried it

Answer 11

Sanjay Tiwari But in this query there is no function. Which DBMS you are using?

It's working on SQL management studio.

ROWNUM works in Oracle
TOP works in SQL
LIMIT works in MySql

Answer 12

I am using oracle 11g express edition

Answer 13

Can you please write it according to oracle's syntax