What is a Subquery in T-SQL

Kris Wenzel
Tutorial de vídeo gratuito de Kris Wenzel
Let me teach you SQL using simple to understand English.
4,3 calificación del instructor • 4 cursos • 5.078 estudiantes

Descripción de la clase

After completing this course know what subqueries are, and how to recognize them within a SQL query.

Para obtener más información, realiza el curso completo

Subquery Magic: Write awesome SQL, Master T-SQL Sub Queries

Take the mystery out of subqueries & take your SQL to the next level. Use SQL Server & write data driven nested queries.

02:47:13 de vídeo bajo demanda• Actualizado Abril 2020

  • Write subqueries and use them in various parts of a query, such as the FROM, WHERE, and HAVING clauses.
  • Gain the confidence to know when to use a sub query.
  • Solve complex problems, such as incorporating one query's results, into another's filter criteria.
  • How to write a correlated subquery (this is a big deal)
  • Solve problems, otherwise impossible to solve using SQL alone, using sub queries.
None None