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