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
- 7210 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 text delimiter?
write a query to mysql in safe mode and to change the root password
What does "i_am_a_dummy flag" do in mysql?
What is index length in mysql?
Explain the difference between mysql and mysqli interfaces in PHP?
How many tables will create when we create table, what are they?
How many tables will create when we create table, what are they?
Write a query to count the number of rows of a table in mysql.
What is a csv table?
What is the latest version of mysql?
How does mysql store dates?
How do I create a stored procedure in mysql?
-
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)
