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
- 7617 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / roger
LIMIT 0,4 will return 5 records because it starts with 0.
It should be LIMIT 0,3
SELECT prodid, prodname FROM products limit 0,3
| Is This Answer Correct ? | 16 Yes | 6 No |
Answer / vigneshram
select nid, prodname from products limit 0,4
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / surya prakash
SELECT prodid, prodname FROM products limit 4;
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / anil alpati
No need to adding offset value. since your question says starting from first 4 records
Below is my query -
select nid, prodname from products limit 4
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sql
Definition: Limit is used to limit your MySQL query results
to those that fall within a specified range. You can use it
to show the first X number of results, or to show a range
from X - Y results. It is phrased as Limit X, Y and included
at the end of your query. X is the starting point (remember
the first record is 0) and Y is the duration (how many
records to display).
Also Known As: Range Results
Examples:
SELECT * FROM `your_table` LIMIT 0, 10
This will display the first 10 results from the database.
SELECT * FROM `your_table` LIMIT 5, 5
This will show records 6, 7, 8, 9, and 10
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
How to use triggers to track changes in mysql?
What is ACID?
How do you start MySQL on Linux?
How to validate email addresses in mysql?
What are the different types of triggers in mysql?
How many rows can mysql hold?
What is difference between unix timestamp and mysql timestamp?
How MySQL is different from SQL?
17 Answers HCL, IBM,
How do you insert a table?
How to delete a table.
How to increment dates by 1 in mysql?
What are the different table present in MYsql?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
