Question

如何查询sql中字段为varchar类型的最长的条数？

一张表某个字段为varchar、想查询该表中、存的最长的一条记录、怎么查？

Answer 1

SELECT TOP 1 * FROM [表名字] WHERE LEN(那个字段) = MAX(LEN(那个字段))

Answer 2

SELECT 字段名, len([字段名]) as 别名 FROM 表名 order by 别名 desc

Answer 3

select *, max(len(字段名)) from tablename

Answer 4

select count(*) from table_name where column in (select max(cloumn) from table_name)

Answer 5

SELECT * from table_name a WHERE length(a.column)=(SELECT MAX(length(COLUMN)) from table_name b );