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?

sql server to day question

CREATE TABLE mytable ( id INT, name VARCHAR(10) );

 GO

 INSERT mytable ( id, name )

 VALUES 

 ( 1, 'S' ), 

 ( 2 , 'P'),

 ( NULL, 'Q' ), 

 ( 4, 'T' ), 

 ( NULL, 'M' ), 

 ( 6, 'N' ); 

 SELECT COUNT(*) FROM mytable;

ANSWER: 
1) 2

2) 4

3) 6

4) NULL


post the right answer