Viewing 15 posts - 61 through 75 (of 91 total)
Yes, hopefully admins would see into this. and rectify accordingly. :unsure::sick:
September 14, 2011 at 1:05 am
The second select statement will return 1, as it will fail only after 1st insert statemnt of dbo.cuss2.
Yes, It's true. The Answer is wrong.
September 14, 2011 at 1:01 am
Prasanthi,
After reading JC's comments I realize that my suggestion is not the right one.
Hence I am suggesting you this better query:
In case you are interested to know 2 or more...
September 12, 2011 at 6:53 am
@richard-2 Warr:
45% incorrect answers would imply that it wasn't an easy question! Well done to those who knew the correct answer or, like me, guessed there would be...
September 12, 2011 at 5:09 am
Try this in case you are just looking for the count and CustomerIds :
select CustomerId, count(*) RechargeNr from customer_trans
group by customerid
having Count(*)>2 and DATEDIFF(day, MIN(RechargeDate), MAX(RechargeDate))<=5
Regards,
Sudhir
September 12, 2011 at 12:28 am
Can you pls just re-format your question with the sql scripts of create table and Insert into table statements?
.. So that someone can help you quickly.
September 11, 2011 at 11:10 pm
Thanks Jason!
Yes, it is an easy question but as you know sometimes we opt to change case sensitivity and our codes become difficult to manage, so the point is...
September 11, 2011 at 1:25 pm
Nice Quote!!
@Jamie:
... instead of saying which question is false, the question asks which one is not true.
September 5, 2011 at 5:24 am
Easy 1. But good to remind me to explore it.
Regards,
September 1, 2011 at 11:18 pm
Viewing 15 posts - 61 through 75 (of 91 total)