How to Write a Query to Find the Longest String in a Column in SQL Server?

Question

Ravi Vishwakarma · Answer

To find the longest string in a column in SQL Server, you can use the LEN function to get the length of each string and then use
ORDER BY in combination with TOP 1 to retrieve the longest string.and 
Here's how you can write the query:
Example 1
-- Technique 1
SELECT TOP 1 [Description]
FROM
    Article
ORDER BY
    LEN([Description]) DESC;
Example 2
-- Technique 2
SELECT TOP 1 [Description], LEN([Description]) AS length_of_string
FROM
    Article
ORDER BY
    length_of_string DESC;
Example 3
-- Technique 3
select top 1 * 
from (
	select [Description], LEN([Description]) AS [S_Length] from Article
) AS Article
order by [S_Length] desc
Example 4
-- Technique 4
select top 1 * 
from (
	select 
	[Description], 
	LEN([Description]) AS [S_Length],
	ROW_NUMBER() OVER( ORDER BY LEN([Description]) DESC) AS ROWNO
	from Article
) AS Article
Output
and 
Read more
Explain the SQL Server backups and their types
Define the PIVOT Table with examples in the SQL server.
MERGE statement in SQL Server to perform upserts
Explain the SQL CURSOR with an example.
and

forum

How to Write a Query to Find the Longest String in a Column in SQL Server?

ICSM Computer

Can you answer this question?

1 Answers

Liked By