econz icon

Firebird - Common Table Expressions (CTE)

econz | PRO | 03/07/12 06:18:03 PM UTC | 0 ⭐ | 708 👁️ | Never ⏰ | []
SQL |

140 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
WITH Tab_Cidades_RS AS (
  SELECT C.*
  FROM Cidade C
  WHERE
  C.UF='RS'
)
 
SELECT * FROM Tab_Cidades_RS
WHERE
DescCidade starts WITH 'F'

Comments