Register

DBMS sql query on null

• edited by
410 views
0 votes
0 votes

Student table

ROLLNO NAME MARKS1 MARKS2
1 T 50 30
2 S 70 99
3 D NULL 10
NULL NULL 78 NULL
NULL NULL NULL NULL

a)  select count(MARKS1) from student;

b)  select count(*) from student;

• edited by
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
1
Shubhanshu asked Dec 24, 2018
1,312 views
Ace Test Series: DBMS - Correlated Sql Query
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
According to me it should be – “Retrieve the names of all students with a lower rank, than all students with age < 18 ”
User Avatar
0 votes
0 votes
1 answer
3
rayhanrjt asked Jan 6, 2023
772 views
SQL Query
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
Write SQL command to find DepartmentID, EmployeeName from Employee table whose average salary is above 20000.
User Avatar
2 votes
2 votes
1 answer
4
Subhrangsu asked Jun 18, 2022
447 views
Write SQL query
Write SQL query to show all employees hired on June 4,1984 (non-default format) emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
Write SQL query to show all employees hired on June 4,1984 (non-default format)emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
User Avatar
Link Copied!