SQL Homework – August 2020 – More DML Triggers

Leave a comment

August 13, 2020 by Kenneth Fisher

Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was unavoidable but I’m back and since it’s a bit late in the month (I generally try to post homework at the beginning of the month) let’s do something easy.

Write a select statement

Things you could include so you don’t decide this is too easy to bother with.

  • More than one table
    • INNER join
    • OUTER join
    • CROSS join
  • CTE
  • Subselect(s)
  • CROSS or OUTER APPLY
  • GROUP BY
  • HAVING
  • ORDER BY
  • UNION, EXCEPT, INTERSECT

 
I could go on but I want this to be fairly easy (but not too easy). I mean if you want to push yourself make it so the output is XML or JSON. Maybe throw in a GROUPING SET.

Also, please watch out for formatting and best practices. For example adding semicolons at the end of the command and not using SELECT *. Let’s pretend that whatever query you write is going to be looked at by a potential employer or the community at large.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,155 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: