URI Online Judge Solution SQL | 2608 Higher and Lower Price – Solution in PostgreSQL

URI Online Judge Solution SQL | 2608 Higher and Lower Price – Solution in PostgreSQL

URI Online Judge Solution SQL | 2608 Higher and Lower Price  | Beginner
URI Problem Link –  URI SQL | 2608 Higher and Lower Price Link

Problem Name: SQL | 2608 Higher and Lower Price
Problem Number : URI – SQL | 2608 Higher and Lower Price
Online Judge : URI Online Judge Solution
Category: SQL
Solution Language : SQL, postgreSQL. mySQL

URI Solution SQL | 2608 Higher and Lower Price  Code in SQL, PostgreSQL, MySQL:

SELECT max(price) as price, min(price) as price
FROM products

Demonstration:
Just use the max() and min() function of mySQL. max(atribute_name) returns the max value of that column from the table.
 In this line-

SELECT max(price) as price, min(price) as price

Tags: URI Online Judge Solution, URI OJ Solution list, URI Problems Solution, URI solver, URI all problem solution list, URI SQL | 2608 Higher and Lower Price, URI 2608 SQL Solution, URI Solution – SQL, URI Online Judge Solution, , URI Higher and Lower price solution, URI 2608 solution