Sql Doubt

[sqlhelp]

sql lo column length ela telsukovachu for each row

 

 Len   function kakunda   

 

oka column undi  which has lot of data and  delete chedam ankuntnam   by going through each name category 

but my question is ela sort cheyali to get largest data length 

 

example table ila undi 

 

Id  Name         data 

1   hyd             texttexttext

2   banglore     texttext

3   hyd             texttexttexttext

4   chennai      texttexttext

  

[vikuba]

individual record length adguthunava or table lo una column length aa?

 clarity pls

[arshad]

individual record length adguthunava or table lo una column length aa?

 clarity pls

 

data choodu ba.... Individual adugutundu

[Chap_Athi]

data choodu ba.... Individual adugutundu

i guess he is asking for column length

 

SELECT LEN(column_name) FROM table_name;

[chelsea]

SELECT DATALENGTH(column_name) from table

[andhravodu]

sql lo column length ela telsukovachu for each row

 

 Len   function kakunda   

 

oka column undi  which has lot of data and  delete chedam ankuntnam   by going through each name category 

but my question is ela sort cheyali to get largest data length 

 

example table ila undi 

 

Id  Name         data 

1   hyd             texttexttext

2   banglore     texttext

3   hyd             texttexttexttext

4   chennai      texttexttext

 

max(len) ani kodite column lo max length record di output chestundi kada

[sqlhelp]

max(len) ani kodite column lo max length record di output chestundi kada

this did it  

 

thanks all