Tag archive for ‘Hierarchical query’
How to convert Oracle hierarchical query to SQL Server
Hierarchical query is a one of the most powerful feature supplied by Oracle to retrieve complex hierarchical data from a database. Oracle extended syntax of the SELECT statement allows user to construct compact queries using a set of the keywords, pseudocolumns, operators and functions. The results of the queries are ready to be used [...]