How to Write Select Statement in Teradata

select in teradata

Student_Table
Student_ID  Last_Name  First_Name  Class_Code  Grade_Pt
    423400  Larkins    Michael     FR             0.00
    125634  Hanson     Henry       FR             2.88
    280023  McRoberts  Richard     JR             1.90
    260000  Johnson    Stanley      ?                ?
    231222  Wilson     Susie       SO             3.80
    234121  Thomas     Wendy       FR             4.00
    324652  Delaney    Danny       SR             3.35
    123250  Phillips   Martin      SR             3.00
    322133  Bond       Jimmy       JR             3.95
    333450  Smith      Andy        SO             2.00

SQL Query
SELECT First_Name ,Last_Name ,Class_Code ,Grade_Pt
FROM Student_Table ;

Related Posts

Comments

Popular posts from this blog

SQL for Quantile Function in Teradata

3 Uses of SAMPLE function in Teradata

All You Need NULL Value Functions