What will be the output after running all the following queries? CREATE Table t( val INT ); INSERT INTO t(val) values…
What will be the output after running all the following queries?
CREATE Table t(
val INT
);
INSERT INTO t(val)
values (1),(2),(3),(null),(null),(4),(5);
SELECT count (*) val_count
From t;
SELECT count(Distinct val) val_count
From t;From the BCC Assistant Programmer (CSE) February 2021 – Written (BUET) exam, question 16 of 20.
More from this paper
- Previous: In Linux, History is a very useful command to show you all of the last commands that have been recently used. Grep is a Linux command-line…
- Next: Write a function in Python programming language which takes a filename as a parameter and prints the first 10 lines of the file.
- All questions in BCC Assistant Programmer (CSE) February 2021 – Written (BUET)