Results 1 to 3 of 3
  1. #1
    adnancanada is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    121

    Question With sql query

    I was trying to understand how to use the WITH clause and the purpose of the WITH clause.


    All I understood was, the WITH clause was a replacement for normal sub-queries.
    Can anyone explain this to me with a small example in detail ?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    adnancanada is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    121
    Quote Originally Posted by orange View Post
    Can you give us some context?

    I found this with Google.

    with tbldetail as
    (
    select top 10 *
    from POline
    )
    select *
    from tbldetail ;



    It is working on SQL but not working on teradata giving me error message.

    Failed to execute SQL: Parse Error splitting statement.

    Does sql run it with caluse ?

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums