URI Online Judge Solution SQL | 2608 Higher and Lower Price - Solution in PostgreSQL
URI Online Judge Solution SQL | 2608 Higher and Lower Price | BeginnerURI 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
No comments:
Post a Comment