Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
68 views
in Information Technology by (55.0k points)
closed by

Consider the below given Student table and answer the questions which follow:

(a) What will be the output of select sum(roll)+count(roll)+sum(marks)+count(marks) from student;

(b) Write command to update marks equal to 0 where roll number is NULL.

1 Answer

+1 vote
by (54.6k points)
selected by
 
Best answer

(a) 77

(b) update student set marks=0 where roll is null;

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...