It has been a long time since we ran quiz. So let us get ready for a quiz. The quiz has two parts. You have to get both the parts correct to win Quadcopter with Camera (we will call it drone). We will be giving away a total of 2 Quadcopters.
The quiz is extremely easy and I will ship the Drone anywhere in the world where Amazon will ship it.
Let us jump directly to the quiz. Please complete all the three questions of the contest.
Contest Part 1: Brain Teasers
There are two questions for you in this part of the contest.
Question: There are two 7s. How will you write select statement with a single operator that returns single 7?
Hint: SELECT 7(Answer)7
Question: Write down the shortest code that produces 1 without using any numbers in the select statement?
Hint: SELECT (Answer)
Contest Part 2: Download and Activate Rapid SQL
Question: Download and Activate Rapid SQL.
Hint: You have to download and activate Rapid SQL. If you do not activate Rapid SQL, you will be disqualified for the contest. Why take risk, let us start!
That’s it!
Just answer above questions in the following comments area, in following format.
Remember:
- Use comments area right below the blog to take participation in the contest
- Answer before June 5, 2014 midnight GMT.
- The winner will be announced on June 8.
- The winner will be selected randomly from all the valid answers.
- All the valid answers will be kept hidden till June 5, 2014.
- There will be a total of two winners.
- The contest is open for any country of the world where Amazon ships products.
Reference: Pinal Dave https://darkslategrey-bat-805937.hostingersite.com/ )
163 Comments. Leave new
Question: There are two 7s. How will you write select statement with a single operator that returns single 7?
Ans. select 7&7
Question: Write down the shortest code that produces 1 without using any numbers in the select statement?
Ans. select cast(‘TRUE’ as bit)
Hi Dave,
answers are :
1. select 7&7
2. select (1)
3. I have installed Rapid SQL trial version successfully.
Contest Part 1: Question1 – Select 7 | 7
and Questions2 : Select count(*)
Contest Part 1:
1. SELECT 7 & 7
SELECT 7 | 7
2. SELECT 1
First Ans: SELECT 7 FROM GROUP BY
Second Ans: SELECT COUNT(*)
Hi Pinal,
I have activated the RapidSQL and Its a smart tool. Connect any source, easy to access, have lot of functionality etc.. nice ..
Thanks
Shakeel Ahmad
Question 1: SELECT 7 | 7
Question 2: SELECT EXP(”)
Q1: SELECT 7 | 7
Q2: SELECT EXP(”)
1. SELECT 7`7
2. SELECT TRUE
Select 7 & 7
Select 7 | 7 which gives the output as 7
Select exp($) which gives the output as 1
1. SELECT 7&7
2. SELECT LEN(‘a’)
Hi,
I have a doubt.
Where to mention the shipping address?
Hi Pinal,
Contest Part 1:
Question1 Answer is:- SELECT 7#7
Question2 Answer is:- SELECT COS($)
Hi,
If i download and install RapidSql, how will you come to know?
Also, you have mentioned that we need to activate. IS activate means purchasing the license?
Hi,
Can I send multiple answers, with different Email?
Follow these steps to register RapidSQL:
Hi,
I have one doubt that where to send the answer, In this blog or some else?
Hi Pinal,
I am waiting for your response..
hi
Why my comment is awaiting…
Hi Pinal,
Answer 1. SELECT FLOOR(SQRT(PI()))
Answer 2. SELECT 7&7
SELECT 7 & 7
SELECT DAY($)
select 7&7 — We can also use select 7|7
select ‘1’ — ‘1’ is Char, not a number
— — Alternative options for second part without cheating :)
select exp($) — 6 Chars, but this only works in latest version like SQL 2014
select exp(”) — 7 EXP function is documented only to accept float but it works at least from SQL 2005
select len(‘ ‘) — 8 This is my last option…
—- Not sure of the format but I hope this is okay… vijay.k@live.com (vijred)