w3resource
SQL exercises

SQL: Show all the details of the winners with first name Louis

SQL Basic Select Statement : Exercise-18 with Solution.

Write a SQL query to show all the details of the winners with first name Louis.

Sample table: nobel_win


Sample Solution:

SELECT *
 FROM nobel_win 
   WHERE winner LIKE 'Louis%';

Output:

SQL exercises

Query Visualization:

Duration:

Query visualization of Show all the details of the winners with first name Louis - Duration

Rows:

Query visualization of Show all the details of the winners with first name Louis - Rows

Cost:

Query visualization of Show all the details of the winners with first name Louis - Cost

Practice Online


Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a SQL query to show all details of the Prime Ministerial winners after 1972 of Menachem Begin and Yitzhak Rabin.
Next: Write a SQL query to show all the winners in Physics for 1970 together with the winner of Economics for 1971.

What is the difficulty level of this exercise?



New Content: Composer: Dependency manager for PHP, R Programming