Roopesh Ramklass Book The operator “=ANY” is equivalent to IN operator by admin|Published April 30, 2019 These two queries will produce identical results: IN =ANY
Published October 15, 2017 Alias as a Reserved Word / Keyword Is it possible to use a Reserved Word as an alias? The answer is YES. But you need to double quote this […]
Published September 24, 2017 DEFERRABLE INITIALLY IMMEDIATE DEFERRABLE INITIALLY IMMEDIATE will check constraint violation after each statement being made As you can see the constraint was fired twice […]
Published October 23, 2017 RR , YY and YYYY will interpret variable length years RR, YY and YYYY masks will interpret variable length years, means you can specify both two-digit or four-digit format as shown […]
Published November 22, 2017 Subquery usage with ANY, ALL, IN and =, >, >=, <, <=, <>, !=, ^= and grouping This is a typical situation that can confuse an average student on the exam. We all know that using a subquery that […]