Skip to content

Madhivanan's SQL blog

A modern business theme

  • About Me
  • Contact Us

Month: February 2018

Question of the month February 2018 – Find query that gives different result

Posted on February 28, 2018February 28, 2018 by madhivanan

In SQL Server server, consider the following queries

query 1 : select 12a4;
query 2 : select 12e4;
query 3 : select 12f4;
query 4 : select 12g4;

Only one query will produce different result than others. Find the odd one out

2 Comments
Top 30 SQL blog 2018
Follow Madhivanan's SQL blog on WordPress.com

Recent Posts

  • Moved to new Blog
  • Find out columns with no data
  • How to count number of words in a sentence?
  • SQL_VARIANT datatype and behaviour changes
  • Question of the month May 2018 – Find out erroneous query

Archives

  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015

Categories

  • SQL Server

Follow me on Twitter

My Tweets

Top Posts & Pages

  • When is usage of semicolon necessary?
  • Millisecond values and separator in time values
Blog at WordPress.com.
  • Facebook
  • Twitter
  • Pinterest
  • LinkedIn
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Madhivanan's SQL blog
    • Join 47 other followers
    • Already have a WordPress.com account? Log in now.
    • Madhivanan's SQL blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar