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.
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.
Explore more
Similar questions
Write a python program to accept a line from the user and store that in a file “story.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.
Consider the following unsorted list
79 19 43 52 3 95
Write the passes of bubble sort for sorting the list in ascending order till the 3rd iteration.
Write the difference between WHERE and HAVING clause.
Define Child pornography.
Define ReIndexing.
Rewrite the following python code after removing any/ all syntactical errors with each correction underlined:
Write a function to read the content from the file and display each word in reverse order.
Write definition of a method ZeroEnding(SCORES) to add all those values in the list of SCORES, which are ending with zero (0) and display the sum.
For example,If the SCORES contain [200,456,300,100,234,678]The sum should be displayed as 600.
List two measures to secure a network.