tricky SQL questions please

[mettastar]

emanna tricky SQL questions unte please post here

want to brush my skills .. online lo antha regular group by lu rank lu join lave dorukuthunayi

[samaja_varagamana]

Idhi gurthupetko naku job lo issue raganey ikkada estha entha brush chesthavo sustha 

[mettastar]

I want now.. meru general ga interview lo face chesina questions or meru interview chesetapudu adige questions veyandi

[sri_india]

Just now, mettastar said:

I want now.. meru general ga interview lo face chesina questions or meru interview chesetapudu adige questions veyandi

select all rows from emp table???

[rakeshchinna]

which SQL in specific. Microsoft, Oracle, IBM, Teradata??

[mettastar]

Just now, sri_india said:

select all rows from emp table???

[mettastar]

Just now, rakeshchinna said:

which SQL in specific. Microsoft, Oracle, IBM, Teradata??

generic bhayya .. edaina parledu.. syntax lu koncham atu itu unna overall concept same kada

[Picha lite]

How to select all rows in a table sql

[mettastar]

Just now, Picha lite said:

How to select all rows in a table sql

orey landasura questions aapu... genuine adugu

[mastercheif]

1 minute ago, mettastar said:

generic bhayya .. edaina parledu.. syntax lu koncham atu itu unna overall concept same kada

ANSI SQL antaru

[Picha lite]

Just now, mettastar said:

orey landasura questions aapu... genuine adugu

I am not using sql much

[Srimantudu]

Just now, Picha lite said:

I am not using sql much

[mettastar]

3 minutes ago, mastercheif said:

ANSI SQL antaru

emanna questions gurthunte cheppu bhayya

[rakeshchinna]

1 minute ago, mastercheif said:

ANSI SQL antaru

 

This is Input. 

Column
24567898
21456789
21568972
23456987
12345668
15269874
14528963
15893636

 

write sQL to get this output 

 

Column A	Column B
24567898	12345668
21456789	15269874
21568972	14528963
23456987	15893636

[mettastar]

what is the relation vuncle.. question is not clear... 

24567898

->12345668

 

how are these two related? 

first set lo first dhi second set lo first dhi ala relate chesava ?