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
- 5702 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 |
what is a cursor? : Mysql dba
What is mysql database server?
How to delete a column and add a new column to database
What is mysql default database?
What is the difference between a database and a table?
What is prepare statement in mysql?
How many columns can you create for an index?
What are Heap tables?
How do I connect to mysql database?
What is the role of a limit in a mysql query?
Can you tell what are various ways to create an index?
Why do we use views instead of tables?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
