URI Online Judge Solution SQL | 2606 Categories - PostGreSQL Solution - Code

URI Online Judge Solution SQL | 2606 Categories - PostGreSQL Solution - Code

URI Online Judge Solution SQL | 2606 Categories | SQL
URI Problem Link -  link

Problem Name: SQL | 2606 Categories
Problem Number : URI - SQL | 2606 Categories
Online Judge : URI Online Judge Solution
Category: SQL
Solution Language : PostGreSQL

URI Solution SQL | 2606 Categories Code in PostGreSQL:

SELECT products.id, products.name
FROM products
JOIN categories
ON products.id_categories = categories.id
WHERE categories.name like 'super%'

Demonstration:

This is query with join the two table using SQL, WHERE query, and finally like query.

1. JOIN for joining two table
2. WHERE for giving condition
3. LIKE for searching.

Links for learning to solve this problem:

1. Learn SQL Join in W3School
2. Learn SQL WHERE in W3School
3. Learn SQL Like Query in W3School

Tags: URI Online Judge Solution, URI OJ Solution list, URI Problems Solution, URI solver, URI all problem solution list, URI Online Judge Solution SQL | 2606 Categories - PostGreSQL Solution - Code, URI 2606 solution, URI 2606 Categories, 2606 Categories Solution URI online judge, URI 2606 Categories code, 2606 Categories in PostgreSQL URI online judge