Sql Question

[shalini86]

If i have a table X having columns abc.

 

I need to compare column a and b and know if there are any rows matching in them.

 

I need to compare column a and c and know if there are any rows matching in them.

 

[JollyBoy]

single statement or two statements

 

 

SELECT a,b FROM TABLEX

WHERE (a=b) 

 

SLECT a,c FROM TABLEX

WHERE  (a=c)

 

single aite OR use chey 

[pandugadu999]

If i have a table X having columns abc.

 

I need to compare column a and b and know if there are any rows matching in them.

 

I need to compare column a and c and know if there are any rows matching in them.

 

oka table lo column comparing enti...

 

ide kada

 

select  a, b from X

where  a = b

[Bairagi From Bapatla]

+1 for above replies

[ravula]

use self join

[dotnetrockz]

SELECT * FROM table WHERE a = b

SELECT * FROM table WHERE a = c

[libertine]

kotha field ki

[shalini86]

Thanks everyone.

[puli_keka]

SELECT * FROM table WHERE a = b
SELECT * FROM table WHERE a = c

Madhyalo oka UNION padesthe motham rows vasthayi kada.. TS ki kavalsindi adena