SQL Ex Ru: Question 25

It is a try. Not working.

SELECT distinct maker
from
(
SELECT distinct model, ram, speed, rank() over(order by ram asc, speed desc) as pos FROM PC
) AS A
inner join product B
ON A.model = B.model
where a.pos = 1

Advertisements

Leave a comment

Filed under SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s