Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to print longest name in sql

select top 1 Name, len(Name) as city_length from tblPerson order by city_length desc
Comment

PREVIOUS NEXT
Code Example
Sql ::  
Sql :: reset sql auto increment 
:: find nth highest salary of an employee 
:: Oracle Column Names of a table 
:: sql fill na with 0 
Sql :: postgresql list columns 
Sql ::  
:: varchar plsql 
::  
::  
::  
::  
::  
::  
Sql ::  
:: sql auto date 
:: where clause for child record apex 
:: create table with select 
::  
Sql ::  
::  
Sql :: scaffold mysql database 
Sql ::  
Sql ::  
Sql :: mysql grant grant option 
::  
Sql ::  
::  
Sql ::  
::  
ADD CONTENT
Topic
Content
Source link
Name
5+7 =