question please

Ryan Alford18y ago

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')"

18y ago

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

Muhammad Shakir19y ago

select * from worker where status=free;

it will show all workers whose status is free and all department of workers will also include.

Muhammad Shakir19y ago

select * from worker where status=free;

it will show all workers whose status is free and all department of workers will also include.