Select names starting with vowels in sql.
Names starting with vowels in sql. Sql query like start with a eiou. Give each column an appropriate label. Sort the results by the employees first names.
To understand the above syntax let us create a table. Our result cannot contain duplicates. Now lets select student names starting with Vowels.
As an example we have a StudentDetails table first lets select all the results from the table. Input Format The STATION table is described as follows. In case you have more questions related to LIKE and pattern matching I just looked up the MSDN link to add here.
I wrote the following query This worked for me Oracle 11g. Query the list of CITY names starting with vowels ie a e i o or u from STATION. Use regular expressions to filter city names.
Where LAT_N is the northern latitude and LONG_W is the western longitude. Query the list of CITY names ending with vowels a e i o u from STATION. Regular expression for city names that do not start with vowels is aeiou and expression for names do not end with vowels is aeiou.
Select distinct city from station where regexp_likecityaeioui order by city If you do not use UPPER then your test cases in which city name is Weather. To display the records which does not have specific word John as the beginning we have change our LIKE sql command a little by changing the position to the end of the word. Get a list of consonants 3.