Database

select * from TableName where 
(ParentID = '10001') or (ID='10001') or
(ParentID in (select ID from TableName where ParentID = '10001'))

Select * from table where parentid is not null order by parentid, id

union all

Select * from table where parentid is null order by id

SajjadZare wrote:

How can I set a password for DB file and just open it in C# ?

select <br />
case when status=0 then 'inactive'<br />
 when status=1 then 'active' <br />
end  as [Status]<br />
 from tablename

USE AdventureWorks
GO
SELECT VendorID, [164] AS Emp1, [198] AS Emp2, [223] AS Emp3, [231] AS Emp4, [233] AS Emp5
FROM 
(SELECT PurchaseOrderID, EmployeeID, VendorID
FROM Purchasing.PurchaseOrderHeader) AS p
PIVOT
(
COUNT (PurchaseOrderID)
FOR EmployeeID IN
( [164], [198], [223], [231], [233] )
) AS pvt
ORDER BY VendorID;