Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. naren044

    What is difference between count(*) and count(1)

    What is difference between count(*) and count(1)
  2. naren044

    Not able to run query using teradata

    Error message : 3771: Illegal expression in when clause of case expression
  3. naren044

    Equivallent of rownum in TERADATA

    Hi, Can you Tell me what is equivallent of rownum in teradata? Thanks and regards, Narendra
  4. naren044

    Not able to run query in teradata...?

    Hi, Actually my real query which i am using to test datawarehouse is Query 2: Select count(*) from mediafact_stg m Where m.action_id in(1004,1005) AND not exists(select 'x' from Media_event me...
  5. naren044

    Can any one help me to make this query to run using teradata assistant

    Hi all In this query the syntax is correct but I dont no why its not running... Can you check it out please? Query: SELECT CASE WHEN party_x_source.partytypeid IN (SELECT party_x_source.datasourceid FROM party_x_source) THEN 1 ELSE 0 END FROM party_x_source; Thank you Regards, Narendra
  6. naren044

    Not able to run query in teradata...?

    SELECT CASE WHEN party_x_source.partytypeid IN (SELECT party_x_source.datasourceid FROM party_x_source) THEN 1 ELSE 0 END FROM party_x_source; Cant i use subquery in when part of case?
  7. naren044

    Not able to run query using teradata

    Hi, The query which i have written is not running in teradata, I dont know why, syntactically it is correct but not running Giving an error message. Do you have any alternative solution for this query? Query: Select count(*) from mediafact_stg m Where m.action_id...

Part and Inventory Search

Back
Top