October 15, 2015 at 10:33 pm
Comments posted to this topic are about the item Finding Azure SQL Database
October 16, 2015 at 12:05 am
I get 3 rows returned when recreate the table in sql and run the query...
October 16, 2015 at 12:15 am
According to the txt you posted, mytext with myid =3 meets the predicate of the WHERE clause.
MCSE Data Platform; BI
MCITP Database Developer; BI
October 16, 2015 at 1:28 am
Hmm, I'm a little bit surprised the explanation.
October 16, 2015 at 1:58 am
helenlu7 65408 (10/16/2015)
According to the txt you posted, mytext with myid =3 meets the predicate of the WHERE clause.
Yes. And the question reads how many rows are returned, not which row. Row with myid=3 is returned, no others - so that is a total of 1 row(s).
October 16, 2015 at 1:59 am
SQL_kode_kracker (10/16/2015)
I get 3 rows returned when recreate the table in sql and run the query...
Can you script this and post the script here? Either (99% chance) you have a typo somewhere, or you ran into an obscure and so far unknown (to me at least) bug.
October 16, 2015 at 2:08 am
This was removed by the editor as SPAM
October 16, 2015 at 2:17 am
Easy one. Got it wrong though because I wasn't paying attention. Time for the weekend!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 16, 2015 at 2:38 am
I answered expected result 2 but i got notification saying is wrong correct result is 1.
Therefore,I created this scenario on my local DB and there is also i got 2 result :rolleyes:
Can someone tell me why is it so ?
October 16, 2015 at 2:44 am
Mishra
You probably didn't remove spaces between myid and mytext in row "2 Azure SQL Database is very useful for some applications" when you copied it from QotD.
Br.
Mike
October 16, 2015 at 2:49 am
answer says
Row 3 doesn't have a space before, so it does not match.
but it is actually row 2 that does not have the space before, so row 3 is the only row that is returned
2 Azure SQL Database[ ]is very useful for some applications
3 Can you use the[ ]Azure SQL Database[ ]for your organization?
the answer is still 1, as it askes for how MANY rows are returned, not WHICH row is returned
October 16, 2015 at 2:53 am
Thanks Mike for your prompt reply.
Yes i got the result as mentioned on the forum.:-P :hehe:
October 16, 2015 at 3:40 am
andrew_dale (10/16/2015)
answer saysRow 3 doesn't have a space before, so it does not match.
but it is actually row 2 that does not have the space before, so row 3 is the only row that is returned
2 Azure SQL Database[ ]is very useful for some applications
3 Can you use the[ ]Azure SQL Database[ ]for your organization?
the answer is still 1, as it askes for how MANY rows are returned, not WHICH row is returned
Correct - the answer is right but the explanation has a typo.
October 16, 2015 at 5:02 am
The explanation for the answer provided is wrong.
It is Row 2 which does not have a space character before the word "Azure".
Hence it is Row 3 which is correct, not 2 as implied by the explanation.
October 16, 2015 at 5:25 am
Thanks and have a great weekend.
Viewing 15 posts - 1 through 15 (of 29 total)
You must be logged in to reply to this topic. Login to reply