What is Common Table Expression?

Posted by Amatya under Sql Server on 9/6/2017 | Points: 10 | Views : 175 | Status : [Member] | Replies : 1
Hi friends,
I was going to the below mentioned link, but i was unable to know where and for what purpose Common table expression is used for. i have never used it so please guide me so i can make use of CTE

http://techfunda.com/howto/203/create-a-cte-common-table-expression

Thanks
Amatya

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks



Responses

Posted by: Raja on: 9/7/2017 [Member] Starter | Points: 25

Up
0
Down
This is like a temporary table variable however it can be only used just after its creation. In case of Temporary table variable, you can use it any number of times if it is created.

It is very useful to hold some data temporarily so that it can be used in another query.

Try to use as explained in the linked article and you will come to know easily.

The best way to learn is to use it!

Thanks

Regards,
Raja, USA

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response