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

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 :: LoadError: cannot load such file -- mysql2/2.7/mysql2 
Sql :: What is localhost IP and MySql default port no. 
Sql :: sql remove non numeric characters 
Sql :: sql server drop table if exists 
Sql :: create row number in sql 
Sql :: mysql sum cast decimal without round 
Sql :: how to add not null constraint in sql 
Sql :: mysql login console 
Sql :: python mysql search 
Sql :: sql server delete top 1000 
Sql :: postgres describe query 
Sql :: how to check current user in mysql 
Sql :: show all public tables postgres 
Sql :: how to know password of mysql root in linux terminal 
Sql :: pl sql asynchronous procedure calls 
Sql :: centos 8 install mysql 
Sql :: check database status oracle 
Sql :: phpmyadmin delete user 
Sql :: sql server: select column values as comma separated string 
Sql :: mysql user change password 
Sql :: docker run mysql image 
Sql :: insert all in sql 
Sql :: sql insert inserted id 
Sql :: create unique index postgres 
Sql :: remove binlog mysql 
Sql :: postgresql alter table sequence 
Sql :: mysql between date range 
Sql :: sqlalchemy left join 
Sql :: allow external access to mysql 
Sql :: create table in mysql 
ADD CONTENT
Topic
Content
Source link
Name
6+3 =