Re: anyone who know some good SQL interview questions?

Christopher Browne wrote:
> Quoth Bob Badour <bbadour_at_pei.sympatico.ca>:
> > c++student wrote:
> >
> >> Hi
> >> Do anyone who know or has the links to some good SQL interview
> >> questions?
> >> Thanks
> >
> > If you actually learn the material, it won't matter what questions
> > they ask you.
>
> If you had some good questions, that could be handy. Some of us have
> involvement with trying to *hire* would-be DBAs...

Here are 2:

1. How do you do hierarchical query query. (Being asked this back in 1997 @yahoo. Also heard somebody else asked it as well).
2. Name various aggregate string concatenation methods. Not all of them are created equal from performance perspective, of course. The most efficient solutions are the one with user-defined aggregation and the other one leveraging collect function. Don't hastily dismiss the rest, however. If nothing else, the problem of writing a list aggregate is still a great job interview question. You can rate someone's SQL skills (on the scale 0 to 6) by the number of different approaches that she can count.