Answer Posted / nikhil mishra

SELECT Salary FROM tablename order by Salary desc limit 1,1

Is mysql a programming language?

868

---

In mysql, what is the default storage engine?

982

---

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

1609

---

What is the use of i-am-a-dummy flag in mysql?

988

---

How does mysql store data?

917

---

How do I change the max connections in mysql?

874

---

What is definer in mysql trigger?

897

---

What is query log in mysql?

950

---

Is mysql relational?

894

---

How will show all records containing the name "sonia" and the phone number '9876543210'

885

---

How to list or view all databases from the mysql server.

904

---

How to display top 50 rows?

1039

---

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

1024

---

How do I use mysql?

875

---

How many tables we can create in mysql database?

930

---