MySQL select first row – BEST 5 WAYS TO “mysql select first row”

We can learn to mysql select first row using SQL TOP, LIMIT, FETCH FIRST or ROWNUM Clause as well as How to select first and last data row from a mysql result? and Select First Row in each SQL Group By group Example.

mysql select first row Examples

Example 1: To return only one row use LIMIT 1:

SELECT *
FROM tamilrokers
WHERE name = 'suleman'
LIMIT 1

Example 2: php mysql fetch first row
get only one row in mysql

$sql_q = "select stud_id FROM master_tbl where id = 'std_id' LIMIT 1";
$res = mysql_query($sql_q);
while($i = mysql_fetch_array($res)) {
   $j = $i['stud_id'];
}
echo $j;

The SQL SELECT TOP Clause

SELECT TOP 5 * FROM Members;

mysql select first row

SELECT * FROM Members
LIMIT 1;

SELECT * FROM Members
FETCH FIRST 5 ROWS ONLY;

SQL TOP PERCENT Example

SELECT TOP 30 PERCENT * FROM Members;

SELECT * FROM Members
FETCH FIRST 30 PERCENT ROWS ONLY;

ADD a WHERE CLAUSE

SELECT TOP 5 * FROM Members
WHERE member_name='Manshu';

Select First Row in each SQL Group By group

Example 3: SQL ROW_NUMBER

-- Select First Row in each SQL Group By group
USE [CODE]
GO
-- Using CTE to save the grouping data
WITH groups AS (
SELECT [ProfileNm]
      ,[AccountCode]
      ,[Education]
      ,[OrgType]
      ,[TotalEarnings]
      ,ROW_NUMBER() OVER (
                     PARTITION BY [OrgType] 
                     ORDER BY [TotalEarnings] DESC
         	   ) AS [ROW NUMBER]
  FROM [Members]
  )
SELECT * FROM groups
WHERE groups.[ROW NUMBER] = 1

Don’t Miss : MySQL Group By Multiple Columns

Read Also:  WooCommerce REST API CRUD Tutorial From Scratch

Select First Row in each Group Example 2

-- Select First Row in each SQL Group By group
USE [CODE]
GO
SELECT * FROM (
SELECT [ProfileNm]
      ,[AccountCode]
      ,[Education]
      ,[OrgType]
      ,[TotalEarnings]
      ,ROW_NUMBER() OVER (
                     PARTITION BY [OrgType] 
                     ORDER BY [TotalEarnings] DESC
         	   ) AS [ROW NUMBER]
  FROM [Members]
  ) groups
WHERE groups.[ROW NUMBER] = 1
ORDER BY groups.TotalEarnings DESC

How to Get First Record in Each Group in MySQL

How to Get First Record in Each Group in MySQL?

create table item_targets(item varchar(255),charge_date date, sale int);

insert into item_targets(item,charge_date, sale)
     values('A','2025-08-01',250),
     ('B','2025-08-01',852),
     ('C','2025-08-01',6541),
     ('A','2025-08-02',547),
     ('B','2025-08-02',478),
     ('C','2025-08-02',2451),
     ('A','2025-08-03',245),
     ('B','2025-08-03',325),
     ('C','2025-08-03',2241);

GROUP BY to get first date for each group

select item,min(charge_date) from item_targets group by item;

get first record by date group

select item_targets.* from item_targets,
           (select item,min(charge_date) as charge_date
                from item_targets
                group by item) max_targets
             where item_targets.item=max_targets.item
             and item_targets.charge_date=max_targets.charge_date;

How to Select Most Recent Record for Each User?

get the first date for each member id using GROUP BY.

select member_id,min(transaction_date) from member_data group by member_id;

select member_data.* from member_data,
                (select member_id,min(transaction_date) as transaction_date
                     from member_data
                     group by member_id) max_member
                  where member_data.member_id=max_member.member_id
                  and member_data.transaction_date=max_member.transaction_date;

Mysql Get Column Names

Read Also:  Show Multiple Checkbox Checked With Multiple Array Using Php

Example 1: Get the first record of the table targets_team_emails

SELECT * FROM targets_team_emails LIMIT 1;

Example 2: mysql select first row

Get the first record of sale_member_id and targets_member_email from the table targets_team_emails where targets_member_name is Pakainfo.

SELECT 
    targets_member_id, targets_member_email
FROM
    targets_team_emails
WHERE
    targets_member_name = 'Pakainfo'
LIMIT 1;

mysql select first row query without the LIMIT clause

SELECT 
    targets_member_id, targets_member_email
FROM
    targets_team_emails
WHERE
    targets_member_name = 'Pakainfo';

Mysql Full Outer Join

How to select first and last data row from a MySQL result?

//get first row data and last row data

SELECT *
FROM members_tbl
WHERE MemberId = (SELECT MIN(MemberId) FROM members_tbl)
UNION
SELECT *
FROM members_tbl
WHERE MemberId = (SELECT MAX(MemberId) FROM members_tbl);

How to select first and last data row from a mysql result?

//mysql select first row
Select * from Member order by [something] asc limit 1

OR

Select * from Member order by [something] desc limit 1

Ref : https://dev.mysql.com/doc/refman/8.0/en/select.html

I hope you get an idea about mysql select first row.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.