Beefy Boxes and Bandwidth Generously Provided by pair Networks vroom
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

Re: Re: Searching (sybase) Database and SQL help (was: Neophyte needs help.)

by mpeppler (Vicar)
on Jun 27, 2002 at 17:14 UTC ( [id://177851]=note: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


in reply to Re: Searching (sybase) Database and SQL help (was: Neophyte needs help.)
in thread Searching (sybase) Database and SQL help (was: Neophyte needs help.)

Neat.

Unfortunately that SQL statement won't work with Sybase - specifically the 

select ... 
  from (select ...) alias

[download]
syntax is not supported.

Usually the same thing can be achieved with temporary tables (which is what the above will do under the covers anyway), or with some interesting GROUP BY and HAVING clauses.

Michael

Replies are listed 'Best First'.
Re: Re: Re: Searching (sybase) Database and SQL help (was: Neophyte needs help.)
by BlueBlazerRegular (Friar) on Jun 28, 2002 at 10:51 UTC
    Whoops. I'm currently using SQL Server which does allow these types of things and so I thought|assumed that Sybase did too.

    A lesson to all you young Monks out there - this is what happens when you don't test your code (or look in the book to make sure it'll work).

    Going from Sybase to Oracle and now to SQL Server has left me confused on who allows what. I guess I could stay with just the 'core' bits, but that takes all the fun out of things.

    Pat

[reply]
      Yeah - MS-SQL (and Oracle) have added a lot of syntactic sugar at the SQL level...

      Michael

[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://177851]
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    • hippo‥ epoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    • erzuuli‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.