Hi Guys,
i have table like here:
So KeyName and DiskSize corresponding.
And what i want is to get this table:
So for keyName P6-64-Premium_SSD i have 3 keyNames which DiskSizes are bigger or equal: P6-64-Premium_SSD, P20-512-Premium_SSD, P30-1024-Premium_SSD.
For P20-512-Premium_SSD we have P20-512-Premium_SSD (equal) and higher value is P30-1024-Premium_SSD.
For P30-1024-Premium_SSD we have only equal value P30-1024-Premium_SSD.
Database sample in attachment,
How can i write query to achive this?
Please help,
Jacek
i have table like here:
So KeyName and DiskSize corresponding.
And what i want is to get this table:
So for keyName P6-64-Premium_SSD i have 3 keyNames which DiskSizes are bigger or equal: P6-64-Premium_SSD, P20-512-Premium_SSD, P30-1024-Premium_SSD.
For P20-512-Premium_SSD we have P20-512-Premium_SSD (equal) and higher value is P30-1024-Premium_SSD.
For P30-1024-Premium_SSD we have only equal value P30-1024-Premium_SSD.
Database sample in attachment,
How can i write query to achive this?
Please help,
Jacek