Node.js MySQL Min() Function

Node.js MySQL Limit Clause

Last Updated : 07 Oct, 2021

LIMIT Clause is used to set the maximum size of the number of rows in the output of SQL Query.

Syntax:

Select only 3 rows from 1st row of users table.
```
SELECT * FROM users LIMIT 3
```
Select only 3 rows from the 2nd row of the users table.
```
SELECT * FROM users LIMIT 3 OFFSET 1
```

Modules:

mysql: To handle MySql Connection and Queries

npm install mysql

SQL users table preview:

Example 1: Select 3 rows from 1st row of users table

JavaScript

const mysql = require("mysql");

let db_con  = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: '',
    database: 'gfg_db'
});

db_con.connect((err) => {
    if (err) {
      console.log("Database Connection Failed !!!", err);
      return;
    }

    console.log("We are connected to gfg_db database");

    // here is our query
    let query = 'SELECT * FROM users LIMIT 3';

    db_con.query(query, (err, rows) => {
        if(err) throw err;

        console.log(rows);
    });
});

Output:

Example 2: Select 4 rows from 4th row of users table

JavaScript

const mysql = require("mysql");

let db_con  = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: '',
    database: 'gfg_db'
});

db_con.connect((err) => {
    if (err) {
      console.log("Database Connection Failed !!!", err);
      return;
    }

    console.log("We are connected to gfg_db database");

    // notice offset is 3, this means choose from row 4
    let query = 'SELECT * FROM users LIMIT 4 OFFSET 3';

    db_con.query(query, (err, rows) => {
        if(err) throw err;

        console.log(rows);
    });
});

Output: There are only 3 rows from 4th row. so, output contains only 3 rows

Node.js MySQL Min() Function

P

pratikraut0000

Improve

Article Tags :

Similar Reads

PHP | MySQL LIMIT Clause

In MySQL the LIMIT clause is used with the SELECT statement to restrict the number of rows in the result set. The Limit Clause accepts one or two arguments which are offset and count.The value of both the parameters can be zero or positive integers. Offset:It is used to specify the offset of the fir

Node.js MySQL Order By Clause

Introduction: We use the SQL ORDER BY Clause to sort the data with respect to some column value in ascending or descending order. Syntax: SELECT * FROM users ORDER BY name; This will sort all rows of output in ascending order (by default) with respect to name column. SELECT address FROM users ORDER

Node.js MySQL LTRIM() Function

LTRIM() Function is a Builtin Function in MySQL which is used to trim all spaces from left side of input string. Syntax: LTRIM(string) Parameters: LTRIM() function accepts a single parameters as mentioned above and described below. string: String needed to be trimmed from left side Return Value: LTR

Node.js MySQL Min() Function

We will be using Min() function in MySQL to get Minimum value from some particular column. Syntax: MIN(column_name) Parameters: MIN() function accepts a single parameter as mentioned above and described below. column_name: Columnâ€™s name from which we have to return the min value. Return Value: MIN()

Node.js MySQL MID() Function

MID() Function is a Builtin Function in MySQL which is used to get substring of input string between given range inclusive. Syntax: MID(input_string, from, length) Parameters: MID() function accepts three parameters as mentioned above and described below. input_string: Substring of this input will b

Node.js MySQL LEFT() Function

LEFT() Function is a Builtin function in MySQL which is used to get Prefix of a specific size of Given String. Syntax: LEFT(input_string, size_of_prefix) Parameters: LEFT() function accepts two parameters as mentioned above and described below. input_string: We will get prefix of this input stringsi

Node.js MySQL CHAR_LENGTH() Function

CHAR_LENGTH() function is a built-in function in MySQL that is used to get a number of characters in a given string. Syntax: CHAR_LENGTH(input_string)Parameters: It takes one parameter as follows: input_string: It is the given string whose length is to be determined.Return Value: It returns a number

Node.js MySQL LENGTH() Function

LENGTH() Function is a Builtin function in MySQL which is used to get length of given string in bytes. Syntax: LENGTH(input_string) Parameters: LENGTH() function accepts a single parameter as mentioned above and described below. input_string: We will get number of characters of this string Return Va

Node.js MySQL Create Table

Introduction: Learn to create a table in MySQL database using NodeJS. We will see how to use the Create Table command in NodeJS using the MySQL module. Prerequisite: Introduction to NodeJS MySQL Setting up environment and Execution: Step 1: Create a NodeJS Project and initialize it using the followi

Node.js MySQL LOCATE() Function

LOCATE() Function is a Builtin function in MySQL which is used to get position of first occurrence of a pattern in a text when searched from specific position. Note: It is Not Case Sensitive. Syntax: LOCATE(pattern, text, starting_position) Parameters: LOCATE() function accepts three parameters as m