SELECT country,city FROM customers GROUP BY country ORDER BY city DESC

5 Answers   HCL,

---

What is mysql ndb?

0 Answers  

---

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

0 Answers  

---

How we can get the current date in mysql?

0 Answers  

---

Tell us something about heap tables?

0 Answers  

---

---

What is the difference between a Table and a View?

3 Answers  

---

What are date and time functions in mysql?

0 Answers  

---

What are the types of database engines available in mysql?

0 Answers  

---

What?s the default port for MySQL Server?

4 Answers   Yahoo,

---

What does tinyint mean?

0 Answers  

---

How does select query work?

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  

---