Interested to Buy Any Domain ? << Click Here >> for more details...
how to display only 4 records from a table based on a
condition
for ex
i have a table called products
in that nid,prodname are fields
i want to display only any 4 records of perticular product
plz tell me
- 6 Answers
- 7407 Views
- I also Faced
- E-Mail Answers
Answer Posted / cherry-mae
algorithm
An algorithm (pronounced AL-go-rith-um) is a procedure or
formula for solving a problem. The word derives from the
name of the mathematician, Mohammed ibn-Musa al-Khwarizmi,
who was part of the royal court in Baghdad and who lived
from about 780 to 850. Al-Khwarizmi's work is the likely
source for the word algebra as well.
A computer program can be viewed as an elaborate algorithm.
In mathematics and computer science, an algorithm usually
means a small procedure that solves a recurrent problem.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is blob and text in mysql?
How can we run batch mode in mysql?
how we will Show selected records sorted in an ascending (asc) or descending (desc).
Explain the difference between procedure and function in mysql?
What does tinyint mean?
Differentiate CHAR_LENGTH and LENGTH?
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
What is the usage of ENUMs in MySQL?
Can we rollback truncate in mysql?
What is the difference between mysql_fetch_assoc and mysql_fetch_array?
In which language mysql has been written?
What is mysql installer?
What do you mean by % and _ in the LIKE statement?
How to upload a large file through phpmyadmin in mysql?
What is mysql uuid?
