InterSystems Learning Services| InterSystems

You are viewing as a ‘Guest’.

Topic outline

Reference	Timestamp	Code
Simple query example to retrieve all columns	0:56	select * from University.CourseCatalog
Example query to filter by term and year using an implicit join	1:11	select CourseID, CourseSection, CourseID->CourseName, Instructor, Instructor->FullName from University.CourseCatalog where TermYear = 'Spring2018'
Command to test SQL in Terminal	1:35	do $system.SQL.Shell()

Reference

Timestamp

Code

Simple query example to retrieve all columns

0:56

select * from University.CourseCatalog

Example query to filter by term and year using an implicit join

1:11

select CourseID, CourseSection, CourseID->CourseName, Instructor, Instructor->FullName from University.CourseCatalog where TermYear = 'Spring2018'

Command to test SQL in Terminal

1:35

do $system.SQL.Shell()

What's Next?
What's Next?
To learn more about SQL options within InterSystems IRIS, take the online course InterSystems SQL Overview (30m).