Show Only a Limited Number of Rows in a Table

$("table > tbody > tr").hide().slice(0, 2).show();$(".show-all").on("click", function() {  $("tbody > tr", $(this).prev()).show();});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script><table>  <tbody>    <tr>      <td>1</td>      <td>Alice</td>    </tr>    <tr>      <td>2</td>      <td>Bob</td>    </tr>    <tr>      <td>3</td>      <td>Carol</td>    </tr>  </tbody></table><button class="show-all">Show all</button>

Limit number of displayed table rows

After looking at the code provided in your JSFiddle, I have managed to modify and get this working for you:

https://jsfiddle.net/83krL60s/10/

Basically, all you need to do is put your table inside a div and set it's height.

How to limit number of rows can be store in mysql table?

I think there is no such inbuilt functionality providede by MySQL. One solution is that you can create trigger.

CREATE TRIGGER your_trigger_name
BEFORE INSERT ON your_table_name
FOR EACH ROW
BEGIN
    DECLARE cnt INT;

    SELECT count(*) INTO cnt FROM your_table_name;

    IF cnt = 10 THEN
        SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'You can store only 10 records.';
    END IF;
END;

Try above trigger on your table. Replace your table_name with your_table_name.

Hope this will help you.

How to limit the number of rows displayed in a table?

Both tables and cross-tables have a top N operator allowing to filter rows as your requirement. In your case this is a cross-table based on a datacube:

Select the cross-tab -> filter tab -> Add -> Select your measure -> Operator "Top N" (or "Bottom N", depending on the sort direction of your crosstab)

Please note this approach is much less efficient than grouping and filtering in a dataset query, if it is based on a database.

Want to fetch limited number of rows and display it and in the next page display the rows after that

If you want to fetch the data from the offset in mysql, you can use the keyword like.

SELECT * FROM 'table_name' LIMIT 51,50 

This will fetch item number 51 to next 50 items. I the program you can multiply number (51) to get the further results.

Multiplying syntax depends on which backend are you using suppose you are using, Basically you have to put a loop around it in order to change the offset value.
I am writing the PHP code:

for($i=0; $i< $n; $i++){
    $offset=50*$i;
    $sql = "SELECT * FROM 'table_name' LIMIT {$offset} ,50  "
    ...
    // Now fire this sql query.
}

If you want to do this with Django there is pagination

Limit maximum no. of table rows using Javascript

You are already getting your row count with this part of your code:

var x = document.getElementById("tb1").rows.length;

So just check x to see if that count is less than 10 if so add another row, if not then just return without adding another.

if(x > 9){
   return;
}

Note though that rows.length when accessed from your table element will return the number of all rows, this includes those that might be in a thead,tfoot and any tbody.

So if you end up wanting to make sure thead,tfoot, or a certain tbody has a certain number of rows then you have to access rows.length from that particular element

//For thead
var num_rows = document.querySelector("#tb1").tHead.rows.length;
//For tbody, [0] swap 0 with the whichever tbody index you want to check
var num_rows = document.querySelector("#tb1").tBodies[0].rows.length;
//For tFoot
var num_rows = document.querySelector("#tb1").tFoot.rows.length;

Demo

var mainBody = document.querySelector("#tb1").tBodies[0];
document.querySelector("button").addEventListener("click", function() {  var num_rows = mainBody.rows.length;  if (num_rows > 9) return;
  var row = mainBody.insertRow();  row.insertCell(0).textContent = "Row "+(num_rows+1);  row.insertCell(1).textContent = "Col 2";  row.insertCell(2).textContent = "Col 3";});

<table id="tb1">  <tbody>    <tr>      <td>Row 1</td>      <td>Col 2</td>      <td>Col 3</td>    </tr>  </tbody></table>
<button>Add Row</button>

"SELECT * FROM Orders ORDER BY orderid DESC LIMIT 20"; 

CREATE TABLE person (id INTEGER UNIQUE PRIMARY KEY, firstname TEXT, lastname TEXT);
CREATE TABLE event (id INTEGER UNIQUE PRIMARY KEY, event_name TEXT, capacity INTEGER);
CREATE TABLE registration (id INTEGER UNIQUE PRIMARY KEY, event_id INTEGER , person_id INTEGER);

INSERT INTO person (id, firstname, lastname) VALUES (1, 'Bob','Barker'),(2, 'Jamie','Oliver'),(3, 'Gary ','Busey');

INSERT INTO event (id, event_name, capacity) VALUES (1, 'Fireman''s Ball', 2);

CREATE OR REPLACE FUNCTION check_registration_capacity()
  RETURNS TRIGGER AS $$
BEGIN
  IF (SELECT count(*) FROM registration as r1 WHERE r1.event_id = NEW.event_id) > 
     ((SELECT capacity FROM event WHERE event.id = NEW.event_id) - 1)
  THEN
    RAISE EXCEPTION 'Event is full';
  END IF;
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER verify_registration_capacity 
BEFORE INSERT OR UPDATE ON registration 
FOR EACH ROW EXECUTE PROCEDURE check_registration_capacity();

-- register Bob for the Fireman's Ball
INSERT INTO registration (id, event_id, person_id) VALUES (1, 1, 1); 
-- register Jamie for the Fireman's Ball
INSERT INTO registration (id, event_id, person_id) VALUES (2, 1, 2);
-- sorry, Gary, the next line throws an 'Event is full' error
INSERT INTO registration (id, event_id, person_id) VALUES (3, 1, 3);