sql finding longest and shortest names in a fleld

Solutions on MaxInterview for sql finding longest and shortest names in a fleld by the best coders in the world

Search
showing results for - "sql finding longest and shortest names in a fleld"
Braelyn
21 Apr 2016
1# IN the example below, "CITY" is the filed, "STATION" is the Table
2(SELECT CITY, LENGTH(CITY)
3FROM STATION
4ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1)
5UNION
6(SELECT CITY, LENGTH(CITY)
7FROM STATION
8ORDER BY 
9LENGTH(CITY) DESC, CITY DESC LIMIT 1)
similar questions
find out the name highest salary sqlhow to find the most occuring in sqlfind lowest number in sqlhow to find max and min salary in sqlconsecutive numbers sqlfind most frequent value in sql columnhow to print longest name in sqlsql find second highest salary employeefind most frequent word in sql serversql find longest running job stepselect statement to print longest namesql select most frequent value in columnsql string lengthsql lengththird highest salary in sqlsql min and max in same queryfirst max salary in sqlsql highest salary by locationsecond last highest id in sqlquery to find 2nd largest salary in sqlvarchar max length sql serverhow to find lowest in sqlmysql get longest string in column2nd max salary query in sqlmin and max salary and name in sqlfind second max salary query sql
queries leading to this page
get longest name sql without order byhow to find longest and shortest varchar sqlhow to print the length min length of city in sql queryhow to find shortest string in sqlsql select shortest and longest stringlongest and shortest sqlsql query with shortest and longest namexysquery to find shortest and longest name in sqlhow to find shortest and longest name in sql using joinsql select shortest string namehow to find longest and shortest string in sqldisplay smallest and longest length in sqlhow to find shortest and longest name in sql using subquerysql shortest and longest city namehow to find shortest and longest string in sqlsql finding longest and shortest names in a fleldshortes and longest name sqlhow to find shortest and longest name in sqlshortest and longest city name in sqlshortest and longest name in sqlquery the shortest and longest name in sqlsql query to find the smallest length of a stringhow to find longest name and shortest name in sqlhow to select the longest and shortest length in sqlget longest name sqlsql show the one with the longes and the shortestfind the longest and shortest name sqlsql get longest stringget shortest and longest names sqlsql select longest and shortest stringsql find longest stringsql finding longest and shortest names in a fleld