SQL SEVER INTERVIEW QUESTION

1. What is  the default "SORT" order for SQL SEVER?


2. select adresses which are between  " 1/1/2015" and "1/04/2015" ?

3.why should you use CTE rather than using simple views?