write a query to display employee names starting with constant and ending with vowels
plz help with this
Answers
Answer:
Query the list of city names ending with vowels (a e i o u) from station in oracle
Query the list of CITY names ending with vowels (a, e, i, o, u) from , Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. SELECT DISTINCT city FROM station WHERE city REGEXP '[aeiou]$'; For MySQL as well as Oracle: If we want to print the city name which For MySQL as well as Oracle: If we want to print the city name which starts with vowels(a,e,i,o,u) then we can use the query which is given below.. SQL>select city from STATION where city LIKE 'a/A %' OR city LIKE 'e/E %' OR city LIKE 'i/I %' OR city LIKE 'o/O %' OR city LIKE 'u/U %'; Here we can write either lowercase or uppercase letter and we can get our desired output.
In SQL I want to display the names of all those cities which end with an, In SQL I want to display the names of all those cities which end with an vowel · sql oracle. I wrote the following query This worked for me (Oracle 11g): select distinct city from station where regexp_like(city,'[aeiou]$','i') order by city If you do not use UPPER, then your test cases in which city name is Weather Observation Station 7. Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. Input Format. The STATION table is described as follows:
SQL query to check if a name begins and ends with a vowel, Sign up or log in to view your list. SELECT distinct City FROM STATION WHERE City LIKE '[A,E,I,O,U]%[A,E,I,O,U]'. Update --Added Oracle Query and $ anchor the match to the beginning and end of the value. SELECT * FROM table WHERE name LIKE 'a%' AND name REGEXP '[aeiou]$' UNION Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude.