reuse a piece of code in SQL?
500719Mar 23 2006 — edited Mar 23 2006I have a big SQL. And inside it, there is a piece of sub-query appear twice. So rather than writing the sub-query twice in the big SQL, I hope to reuse the sub-query in the "big SQL", i.e., is it possible that I only write it when it first appears, and when it appears again in the other places in the same big SQL, I only need to refer to it rather than re-write the whole sub-query once again? Hope the above does not confuse you. Thanks!