Showing posts with label sql server quries. Show all posts
Showing posts with label sql server quries. Show all posts

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