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 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
Fill the statement 1 and Statement 2 according the requirement of output dataset:
Define Child pornography.
Difference between pivot() and pivot_table().
Define Series in Pandas.
What are the best case and worst case in sorting techniques?
Write the output of the given python program :
Find the output
Write definition of a Method COUNTNOW(PLACES) to find and display those place names, in which there are more than 5 characters.
For example:If the list PLACES contains [''DELHI'', ''LONDON'', ''PARIS'', ''NEW YORK'', ''DUBAI'']The following should get displayedLONDONNEW YORK
A text file “Quotes.Txt” has the following data written in it: "Living a life you can be proud of Doing your best Spending your time with people and activities that are important to you Standing up for things that are right even when it’s hard Becoming the best version of you." Write a user defined function to display the total number of words present in the file.
Write one advantage of Star Topology of network? Also, illustrate how 5 computers can be connected with each other using Star topology of network.