Re: Hierarchical query

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 22 Mar 2005 18:16:17 +0100
Message-ID: <42405290$0$32183$626a14ce@news.free.fr>

"kirtan" <kirtan.acharya_at_gmail.com> a écrit dans le message de | news:1111471589.946014.33910_at_o13g2000cwo.googlegroups.com...
| I agree it can be done without the extra column. But my point was that
| is is not a good design strategy. If you wanted to add a row under
| (lets say) Salary, what would be the id/number you would assign to it?
| If the table is a static table, it is not much of an issue, but if it
| is going to be updated often, then an extra column is needed.

| kirtan.

There is nothing in the OP question about the purpose of this table/query or the meaning of its content so all the answers are satisfactory, even Kerul static query.

Regards
Michel Cadot Received on Tue Mar 22 2005 - 11:16:17 CST