select query

C# Corner

select query

lejo

3y800SQL Server

i have 3 employees 5 record in transaction table i want to select only 2 records of ecch emplyee in select query

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh3y ago

Accepted answer

There are multiple ways

select * from (select *, Row_Number() over (partition by empName order by empId) as RN from tableName)t

where RN<=2

Vishal Joshi3y ago

Hello

Try below query.

SELECT *
FROM employeeTable empParent
WHERE (
            SELECT  COUNT(*) 
            FROM    employeeTable  empsub
            WHERE empsub.name = empParent.name 
        ) <= 2