Download App

Database Management – SQL — Computer Science STD 12 Science — Question

CBSE BoardEnglish MediumSTD 12 ScienceComputer ScienceDatabase Management – SQL2 Marks
Question
Write the difference between WHERE and HAVING clause.
✓

Answer

WHERE clause is used for selecting the rows based on the condition applied on rows. While HAVING clauses used to select the rows from the data given by group by group by clause in SQL.

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free

Explore more

More "2 Marks Each" from Database Management – SQL→Database Management – SQL — all question types→Computer Science STD 12 Science question papers→CBSE Board STD 12 Science question papers→CBSE Board question paper generator→

Similar questions

Write one advantage of Star Topology of network? Also, illustrate how 5 computers can be connected with each other using Star topology of network.
→
Write a program to Read the content of the file line by line and print without ‘n’. Assuming that file name is “multiline.txt”. 
→
Write the python script to connect the database, i.e.test and create the table emp21 with the following field (empno,name and salary). Also, insert the row.
→
Write a program to read the content of the file line by line and display. Assuming that file name is “multiline.txt”. 
→
Differentiate between the terms primary key and alternate key.
→
Write a program using function to accept a number from the user and print sum of its first n natural numbers.  
→
Write a Python programming to display a bar chart on the popularity of Programming Languages.

Sample data:

Programming languages: Java, Python, PHP, JavaScript, C#, C++ Popularity: 22.2, 17.6, 8.8, 8, 7.7, 6.7

→
What is the purpose of Modem in network?
→
Write the difference between WHERE and HAVING clause.
→
What is the POCSO Act?
→