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
SELECT CAST(‘True’ AS BIT)
SELECT LEN(‘a’)
SELECT 7&7
SELECT 7|7
1. SELECT 7 & 7
2. SELECT Count(*)
3. Done (email used: m_umair_85@hotmail.com !)
Select exp ($) which produces 1
1) SELECT 7 & 7
2) SELECT $/$ or SELECT COS($)
3) Activated with my email address
Contest Part 1
1. SELECT 7 HAVING COUNT(*) < 7
2. SELECT EXP($)
I have successfully downloaded and activated Rapid SQL with my email id : milsonmun@yahoo.com
select 7&7
select count(*)
#1 – SELECT 7%17
#2 – select LEN(‘h’)
#3 – done
Roy Jackson
rjackson@spatialsigil.com
Better answer:
select 7 | 7
select len(‘a’)
Betterer answer:
select 7 | 7
SELECT cos($)
select 7|7
select @@ROWCOUNT
These are the most concise answers I can think of;
1. Select 7&7 2. Select CAST(‘TRUE’ as bit) 3. fyi – DoD lists this as a black hole site. I’ll download at home.
You can also use the bitwise operator for ‘or’ instead of the bitwise operator for ‘and’, i.e.;
Select 7|7
I feel like there must be a shorter statement for Q2, but darned if I can think of it.
Tony
Hi Pinal Dave,
Here are my answers:
1. select 7 | 7
2. select len(‘a’)
1) select 7 | 7
2) select len(‘o’)
3) I downloaded and activated Rapid SQL
select 7 — 7
select len(‘a’)
Can I change my answer? If yes, then I would propose: select 7|7
May be this will return 7
select 7 +7- 7
Hi,
*Question:* There are two 7s. How will you write select statement with a single operator that returns single 7?
Hint: SELECT 7(Answer)7 SELECT 7 *(+7-)* 7
Thanks Justine
Yours Sincerely,
*Justine Clement A.*
Hi Pinal,
My answers below:
–Question: There are two 7s. How will you write select statement with a single operator that returns single 7?
select 7 | 7
–Question: Write down the shortest code that produces 1 without using any numbers in the select statement?
select count(*)
— I have also installed and activated Rapid SQL. I will take it for a spin these days :)
Contest Part 1:
Question01 Answer: SELECT 7|7
Question02 Answer: SELECT COS($)
Contest Part 2:
Registration and Activation Complete
Answer:
Question1: select 7 & 7
Question2:select count(*)
Part 1
SELECT 7|7
SELECT LEN(‘A’)
Part 2
What do you mean by download and activate? Do I have to buy that application?
1. SELECT 7 & 7
2. SELECT cos($)
&
count(*)