martes, 30 de marzo de 2021

A Sql Query as a table

If we need to use a subquery as a table of a query in SQL the next example is the right way to do it
  SELECT table2.field_name
      FROM (
          SELECT *
          FROM table1
      ) AS table2
  WHERE table2.field_criterium = 'x'

No hay comentarios:

Publicar un comentario

Popular Posts

Conoce Manizales !!

La intranet de Manizales