T SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ram Mohan Reddy » T SQL

74 posts, Page 8 of 8

«««4 5 6 7 8

T SQL

Rate Topic

Display Mode

Topic Options

Author

Message

myates7

Posted Friday, May 29, 2009 10:26 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, April 19, 2013 1:49 PM
Points: 1,621, Visits: 108

The problem is that the order by clause was left out on the initail page.

Today's Question:

What is the output for the query below?

CREATE TABLE E (eid int, mid int, en char(10) )
INSERT E SELECT 1,2,'Vyas'
INSERT E SELECT 2,3,'Mohan'
INSERT E SELECT 3,NULL,'Shobha'
INSERT E SELECT 4,2,'Shridhar'
INSERT E SELECT 5,2,'Sourabh'
SELECT t1.en [Em], t2.en [Ma] FROM E t1, E t2 WHERE t1.mid = t2.eid

when you click the "Click Here" the question has an additional line with the order by clasue

CREATE TABLE E (eid int, mid int, en char(10) )
INSERT E SELECT 1,2,'Vyas'
INSERT E SELECT 2,3,'Mohan'
INSERT E SELECT 3,NULL,'Shobha'
INSERT E SELECT 4,2,'Shridhar'
INSERT E SELECT 5,2,'Sourabh'

SELECT t1.en [Em], t2.en [Ma] FROM E t1, E t2 WHERE t1.mid = t2.eid

order by t1.en

Post #725937