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 :: if then else sqlite 
Sql :: tsql replace value in json 
Sql :: clear screen command in psql 
Sql :: sql today at midnight 
Sql :: How to View column names of a table in SQL 
Sql :: oracle character set 
Sql :: transalations from sql to Linq count and group by 
Sql :: login to mysql 
Sql :: sql myisam vs innodb 
Sql :: postgres alter table add column with default value 
Sql :: sql drop database statement 
Sql :: import file mysql terminal 
Sql :: show tables sql 
Sql :: mysql concatenate columns 
Sql :: oracle asynchronous update 
Sql :: wsl install mysql 
Sql :: mysql Like(searching in the string) 
Sql :: shell mysql connect 
Sql :: sql random number between 1000 and 9999 
Sql :: oracle index partition 
Sql :: mysql remote connection command line 
Sql :: MySQL FIND_IN_SET() 
Sql :: show columns in sql 
Sql :: enable service broker in sql server 
Sql :: sql where contains 
Sql :: get top 10 records in oracle 
Sql :: what is the default password for sql server sa 
Sql :: mysql version query 
Sql :: sql convert xml to text 
Sql :: sql count group by 
ADD CONTENT
Topic
Content
Source link
Name
5+2 =