SELECT country,city
FROM customers
GROUP BY country
ORDER BY city DESC
Answer Posted / prajakta
this is right coz here order by clause is at the end of
query...
| Is This Answer Correct ? | 21 Yes | 3 No |
Post New Answer View All Answers
What are the types of queries?
What are mysql queries?
How do you login to MySql using Unix shell?
What sql does mysql use?
What is 'mysqladmin' in mysql?
What is delimiter $$?
Write a query to fetch duplicate records from a table using mysql?
What does mysql flush privileges do?
Where is the mysql config file?
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
How much does mysql enterprise cost?
What is datatype in mysql?
Which command is used to view the content of the table in mysql?
How do I install the latest mysql on ubuntu?
Do you need a license for mysql?