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.
- JOIN for joining two table
- WHERE for giving condition
- LIKE for searching.
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