explain GROUPBY & HAVING clause with examples.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?

4 Answers  


How to include numeric values in sql statements?

0 Answers  


What is 'mysqlimport'?

0 Answers  


What is blob and text in mysql?

0 Answers  


How to create table show example

0 Answers  






Is mysql free software?

0 Answers  


Does uninstalling mysql delete database?

0 Answers  


How do you select a table?

0 Answers  


Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers  


How can we encrypt and decrypt a data presented in a table using mysql?

0 Answers  


Why do we use preparedstatement?

0 Answers  


Can you tell how many values can set the function of mysql to consider?

0 Answers  


Categories