SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


T SQL


T SQL

Author
Message
Raamamohan
Raamamohan
SSChasing Mays
SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)

Group: General Forum Members
Points: 645 Visits: 139
Comments posted to this topic are about the item T SQL
Atif-ullah Sheikh
Atif-ullah Sheikh
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5198 Visits: 5204
Typing error in the answer,w00t


Row 1 - Vyas Mohan | Row 2 - Mohan Shobha, Shridhar | Row 3 - Mohan | Row 4 - Sourabh Mohan


The correct answer is

Row 1 - Vyas Mohan | Row 2 - Mohan Shobha | Row 3 - Shridhar Mohan | Row 4 - Sourabh Mohan

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here


Rahul Prajapati
Rahul Prajapati
SSC Eights!
SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)SSC Eights! (886 reputation)

Group: General Forum Members
Points: 886 Visits: 334
Answer shown in this question is wrong in.

I had tried SQL and i get rows like shown below.

row1 - Vyas Mohan
row2 - Mohan Shobha
row3 - Shridhar Mohan
row4 - Sourabh Mohan
Raamamohan
Raamamohan
SSChasing Mays
SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)

Group: General Forum Members
Points: 645 Visits: 139
It is the correct Answer:
Row1: Vyas Mohan
Row2: Mohan Shobha
Row3: Shridhar Mohan
Row4: Sourabh Mohan

You can chose :

Row1: Vyas Mohan
Row2: Mohan Shobha ,
Shridhar Row3: Mohan
Row4: Sourabh Mohan

Becasue after posting the question, Row3 and Sridhar has been swapped. I dont know how it has been swapped!!!:-)
Udayaprakashc
Udayaprakashc
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 14
Blink Your answer for this question is wrong.I executed the query in the SQL but the answer is like this.....

Vyas Mohan
Mohan Shobha
Shridhar Mohan
Sourabh Mohan

It is in the third option...So now i losed my pointAngry


Regards,
Uday
Raamamohan
Raamamohan
SSChasing Mays
SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)

Group: General Forum Members
Points: 645 Visits: 139
Your are wrong Mr Uday:

Check the third results:

| Row 1 - Vyas Mohan
| Row 2 - Mohan Shobha
| Row 3 - Shridhar Mohan
| Row 4 - Sourabh Shridhar

Answer: Fisrt Set (First Option)
mverma4you
mverma4you
Mr or Mrs. 500
Mr or Mrs. 500 (549 reputation)Mr or Mrs. 500 (549 reputation)Mr or Mrs. 500 (549 reputation)Mr or Mrs. 500 (549 reputation)Mr or Mrs. 500 (549 reputation)Mr or Mrs. 500 (549 reputation)Mr or Mrs. 500 (549 reputation)Mr or Mrs. 500 (549 reputation)

Group: General Forum Members
Points: 549 Visits: 226
1st option is the correct answer. there is a typo mistake in the option given for the question. I think it;s ok if you look properly the answer then you will not tick the wrong answer. Cool
Joy Smith San
Joy Smith San
SSCertifiable
SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)SSCertifiable (6.6K reputation)

Group: General Forum Members
Points: 6634 Visits: 3200
Getting the following result....

Vyas Mohan
Mohan Shobha
Shridhar Mohan
Sourabh Mohan

Answer given is wrong...
Saurabh Dwivedy
Saurabh Dwivedy
Right there with Babe
Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)Right there with Babe (744 reputation)

Group: General Forum Members
Points: 744 Visits: 340
I too am getting the following answer (like quite a few others)

Vyas Mohan
Mohan Shobha
Shridhar Mohan
Sourabh Mohan

Will the OP shed some light?

Saurabh Dwivedy
___________________________________________________________

My Blog: http://tinyurl.com/dwivedys

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537

Be Happy!
Udayaprakashc
Udayaprakashc
SSC-Enthusiastic
SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)SSC-Enthusiastic (116 reputation)

Group: General Forum Members
Points: 116 Visits: 14
Mr.Ram Mohan,

The answer which I posted previously is the output for your question. But there is no similar options found in your objectives.

Regards,
Uday.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search