how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.


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

Post New Answer

More MySQL Interview Questions

Is mysql free download?

0 Answers  


How to create table show example

0 Answers  


Can mongodb replace mysql?

0 Answers  


What is the maximum number of records in mysql table?

0 Answers  


Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

3 Answers   TCS,






How to enter numeric values as hex numbers?

0 Answers  


What is a mysql server?

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  


Is mysql running ubuntu?

0 Answers  


How can you filter the duplicate data while retrieving records from the table?

0 Answers  


How to dump a table from a database.

0 Answers  


I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

0 Answers  


Categories