Wednesday, January 14, 2015

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


No comments:

Post a Comment