question please

Question

please i hav a question..can uoy answer me?? i have a workers table which contains 4 records such as (idnamecategory status) ... category like : abc i want to write query to obtain 3 workers that their status = free and belong to each category (ab and c ) can you help me ??

Ryan Alford · Answer

SELECT ID  Name  Category  Status FROM WORKERS WHERE Status = 'Free' AND Category IN ('a''b''c') If 'a' 'b' and 'c' are the only possible categories then you can remove  AND Category IN ('a''b''c')

Mohd Azharuddin Ansari · Answer

select ColumnName1ColumnName2 from TableName where ColumnName2 in(select top 3 ColumnName2 from test) and Condition=ConditionExperation

Muhammad Shakir · Answer

select * from worker where status=free; it will show all workers whose status is free and all department of workers will also include.

Muhammad Shakir · Answer

select * from worker where status=free; it will show all workers whose status is free and all department of workers will also include.