How can we use Multiple Queries using 'WITH' Clause

Question

as sample code below....

 WITH sampleA as (SELECT * FROM emp)

 SELECT * FROM sampleA

 SELECT * FROM sampleA

this alias 'sampleA' will work for only first query not for second or later..

But I want to query more with this alias only.

Can you please help me, how can I do that?

why you need second alias,when operation could be completed in teh first statement?? — vhadalgi, Dec 24 '13 at 06:26

score 2 · Answer 1 · answered Dec 24 '13 at 06:22

2

Common table Expression scope is limited to first SELECT statement. For multiple usage , use instead temporay table or table variable.

answered Dec 24 '13 at 06:22

Mudassir Hasan

1 Answers1