Write a query to display the first and the last record from the Employee info table.

Last Post

RSS

Posts: 1

Ramesh k

Guest

Topic starter

May 17, 2022 4:16 pm

(@Ramesh k)

New Member

Joined: 2 years ago

Write a query to display the first and the last record from the Employee info table.

For First Record

SELECT * FROM EmployeeInfo

WHERE EmpID=(SELECT MIN(EmpID)

FROM Employeelnfo);

3 Replies

Posts: 18

jeevan 123

May 17, 2022 4:25 pm

(@jeevan303500)

Active Member

Joined: 3 years ago

For last record

SELECT * FROM EmployeeInfo

WHERE EmpID=(SELECT MAX(EmpID)

FROM Employeelnfo);

first-and-last-record-from-a-table-sql.jpg

Posts: 18

jeevan 123

May 17, 2022 4:37 pm

(@jeevan303500)

Active Member

Joined: 3 years ago

select *from emp order by EmployeeId ASC LIMIT 1)
UNION
(select *from emp order by EmployeeId DESC LIMIT 1);

Posts: 18

jeevan 123

May 17, 2022 4:40 pm

(@jeevan303500)

Active Member

Joined: 3 years ago

+------------+--------------+----------------+
| EmployeeId | EmployeeName | EmployeeSalary |
+------------+--------------+----------------+
| 1          | JohnS     | 457647         |
| 4          | Peter       | 989322         |
+------------+--------------+----------------+
2 rows in set (0.00 sec)