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://blog.sqlauthority.com/ )
163 Comments. Leave new
Hello Sir,
Part 1:
Question 1: Produce Single 7 using 2 7s and single operator
Answer 1 : Select 7&7;
Question 2 : Write Shortest code to product digit 1 without using any number
Answer 2 : Select Len(‘a’);
Part 2:
Downloaded and Activated Rapid SQL Trial Version with the following email id:
skant@sapient.com
I will wait eagerly for the results announcement.
Thanks
Shashi Kant
—-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 ISDATE(GETDATE())
I have activated the Rapid SQL tool and also answered for questions.
Contest Part 1: Brain Teasers
Select 7&7
Select 1
Contest Part 2: Download and Activate Rapid SQL
Downloaded, installed & activated RapidSQL
Answers are as follows
1) SELECT 7 & 7 will produce 7 as output.
2) SELECT LEN(‘*’) will produce 1 as output.
not only one any single alphabetic in the LEN() function will produce output 1
part 1 answers 1. Select 7|7, 2.Select Count(*) and rapid sql is activated
Question 1 – two answers:
SELECT 7&7
SELECT 7|7
Question 2 – four answers:
SELECT CONVERT(BIT,’true’)
SELECT USER_ID(‘dbo’)
SELECT SIGN(@@SPID)
SELECT EXP(”)
The first “teaser” is by using the keyword “mod” – So, SELECT 7mod7 will produce a single 7
/*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 1
/*Product: Rapid SQL XE5 Trial – 14 days
Serial Number(s): MEFE-NX6D5W-LZXPNG-3DBZ
Login Name: aytekoz@yahoo.com
First Name: aytekin
Last Name: ozdemir
*/
Hi Pinal,
My Answers:
Answer 1: SELECT 7|7
Answer 2: SELECT EXP($)
select 7/7*7
select len(‘a’)
Hi Pinal,
Answers of questions are as below:
SELECT 7&7
SELECT CAST(‘true’ AS BIT)
Regards,
Aadhar
Answer #1:
SELECT 7|7
Answer #2:
SELECT LEN(‘a’)
Q&A:
1) select 7 ^7 (SELECT 7(Answer)7)
2) select len(‘A’) SELECT (Answer)
Answer 1 : SELECT 7 | 7
Answer 2: SELECT LEN(‘?’)
Part 1)
Ans 1) &
Ans 2) Count(*)
Answer 1: select 7 & 7
Answer 2: SELECT COS($) Or SELECT DAY($) Or SELECT EXP($)
Answer 3: I have downloaded and activated Rapid SQL
Here are my Information
——————————–
Login Name: yourlast@hotmail.com
First Name: Abdisamad
Last Name: Khalif
I Answered all the question, Question #1 and #2, and i have downloaded Rapid SQL and even activated, i wish good luck.
Thanks Mr Pinal Dave
Answer 1: select 7|7
Answer 2: select LEN(‘a’)
Ans 1) : SELECT 7&7
Ans 2) :SELECT LEN(‘c’)