Answer Posted / satya

SELECT salary FROM emp order by ordering DESC limit 2,1

What is difference between schema and table?

962

---

Write a query to fetch common records between two tables using mysql?

1066

---

What are the non-standard sql commands supported by 'mysql'?

1047

---

What are stored procedures and functions?

954

---

How to enter numeric values as hex numbers?

1030

---

How do I create a mysql username and password?

940

---

What are the different column comparison operators in mysql?

988

---

What is pragma serially_reusable and why is it used?

899

---

What is the current version of mysql?

1016

---

What is mysql aggregate functions? Explain

1156

---

all the queries used in sql

2710

---

What is the full meaning of mysql?

1011

---

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

1688

---

What is the storage engine for mysql?

1004

---

Why myisam is faster than innodb?

991

---