recovering dual table in Oracle
- by Harish
Someone has accidentally dropped dual table.Now we need dual table and whats the way to bring it back to the original state before dropping of the dual table?
I need to delete a sub set of records from a self-referencing table in SQL Server 2008. I am trying to do the following but it is does not like the order by.
WITH SelfReferencingTable (ID, depth)
AS
(
SELECT id, 0 as [depth]
FROM dbo.Table
WHERE parentItemID IS NULL AND [t].ColumnA = '123'
UNION ALL
SELECT [t].ID, [srt].[depth] + 1 …
