Chapter 17 – Interrogating the Data

"The difference between genius and stupidity is that genius has its limits"

- Albert Einstein

Quiz – What would the Answer be?

Sample_Table

Class_Code

 

Grade_Pt

Fr

 

0

SELECT  Class_Code

,Grade_Pt / (Grade_Pt * 2 ) as Math1

FROM Sample_Table

ORDER BY 1,2 ;

image

Can you guess what would return in the Answer Set?

Use the fake table above called Sample_Table, and try and predict what the Answer will be if this query was running on the system.

Answer to Quiz – What would the Answer be?

Sample_Table

Class_Code

 

Grade_Pt

Fr

 

0

SELECT Class_Code

,Grade_Pt / (Grade_Pt * 2 ) as Math1

FROM Sample_Table ...

Get Actian Matrix (Formely ParAccel) - Architecture and SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.