I have a table with data in following order.

ID Career Term Bill_Career

A GR 50 GR
B UGR 50 UGR
C UGR 50 UGR
D GR 50 GR
E UGR 50 UGR
A UGR 50 GR
B GR 50 GR
C GR 50 GR

What I am looking for is, any ID that occures twice with Different Bill_Career.
How can I make the output look like

ID Career Term Bill_Career

B UGR 50 UGR
B GR 50 GR
C UGR 50 UGR
C GR 50 GR

SELECT DISTINCT ID_CARRER_TERM_BILL_CAREER , B UGR , C UGR FROM TABLENAME

Distinct key word has to be used before the column name to eliminate the duplicate values

eg

Select disctinct columname, column from table name where condition.

SELECT B UGR 50 UGR,
B GR 50 GR,
C UGR 50 UGR,
C GR 50 GR FROM TableName;

>What I am looking for is, any ID that occures twice with Different Bill_Career.

It means u r looking for a Unique ID ? Is it?
My answer would be similar to usof but You say you are looking for ID that comes twice?
Would you make your question a lil bit clear?

Hurray, Here is the answer.

select a.id,a.career, a.term, a.bill_career
from rg_semester a, /* this rg_semester table is assumption */
rg_semester b
where
a.id = b.id
and a.bill_career != b.bill_career
and a.id in (select a.id from rg_semester
group by a.id having count(a.id)>1);


ID CAREER TERM BILL_CAREE
-- ---------- ----- ----------
B GR 50 GR
B UGR 50 UGR
C GR 50 GR
C UGR 50 UGR

Good Luck.

Select ID_Career, Bill_term_career
From TableName
Group by ID_Career

Try this and see if it helps.. Let me know too. I will try other query's if this is not what you are looking for.

Think Aryan has nailed it.

if you want to retrive the distinct colums from table then

SELECT DISTINCT ID Career from TableName
Where IDCareer IN ('B','c');

or
SELECT DISTINCT ID career from Tablename
whrere IDCareer like "%b" and "%c";

i am not sure though... just try it...

select a.id,a.career, a.term, a.bill_career
from rg_semester a, /* this rg_semester table is assumption */
rg_semester b
where
a.id = b.id
and a.bill_career != b.bill_career
and a.id in (select a.id from rg_semester
group by a.id having count(a.id)>1);


ID CAREER TERM BILL_CAREE
-- ---------- ----- ----------
B GR 50 GR
B UGR 50 UGR
C GR 50 GR
C UGR 50 UGR

great!

usofa,

if there are 100000 of row, how would you know only 'B' & 'C' id have distinct values in bill_career? The logic wouldn't work. Just my two cents.

Aryan, I am not sure but yours looks right to me.
The way I figured out was :

select A.*
from tablename A, tablename B
where A.ID = B.ID
and A.term = B.term
and A.bill_career <> B.bill_career


Anyway, thanks to everyone.

the last statement should be
A.bill_career <> B.bill_career

not equal

Sajha doesn't let me put that sign

you can put not equal sign different ways.
!= OR <> OR ^=

I agree with Aryan's Query

Can someone explain it in english. The operators, statement etc

The commonl logical operators are
AND,
OR ,
NOT.
there are other types of operators as well. they can be classified as followes.
Comparison Operators
mathematical functions and Ooperators
string Functions and Operators
Binary String Functions and Operators
Pattern Matching