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
- 7436 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 causes mysql too many connections?
What is datatype in mysql?
Which datatype is used for email in mysql?
How do I edit a database in mysql workbench?
What is dbms in mysql?
How do I download a mysql community server?
can you tell the order of sql select statement? : Mysql dba
What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?
How can I insert images into a Mysql database?
Write a query to retrieve a hundred books starting from 20th.
How do I make an action query?
How do you index just the first four bytes of the column?
-
Oracle (3259) - 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)
