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

Latest

It is a free Online judges problems solution list. Here you can find UVA online Judge Solution, URI Online Judge Solution, Code Marshal Online Judge Solution, Spoz Online Judge Problems Solution

Sunday, April 8, 2018

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

No comments:

Post a Comment