Answered: When I order certain StatType ID, it…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

When I order certain StatType ID, it orders based on the number 1-13. However I want to inject certain statType ID into the order. For example

when I do:

Order by p.stat_type_id

It orders the data from 1-13

however I want inject certain statType ID next to each other.

For example:

I want p.stat_type_id=7 and p.stat_type_id=10 to be next to p.stat_type_id=2 and p.stat_type_id=4

so basically then I want the order to be like

1 2 7 3 4 10 5 6 8 9 11 12 13

My code currently

Order by p.stat_type_id

Maybe a simple case statement would solve this problem

Inject certain Stat_type_id to the order

hint here, think about not using new numbers for each stat_type_id, but rather just using the stat_type_id themselves, and then you just need to logically think about how to put 7 between 2 and 3, and 10 between 4 and 5. you only need 2 case statements and then a default case

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions