[Help] how these data will be able to put out on the table? SQL - Examples : Listed : ID NAME AGE WEIGHT A 22 30 01 A 23 30 01 B 23 35 02 In the example may not be appropriate, meaning this : this table ID, the same transportation NAME taken out and the results are as follows A 22 30 01 A 23 30 01 Thank you, the If this issue were not resolved, or may not solve the problem, I will not enter this piece of land Sad! Select * from t Where (id, name) in (Select id, name From t Group by id, name Having count (*), "1) It is better to use the decode () to achieve better There is nothing wrong with the idea withheld But there seems to have grammatical errors Argentina Because where (id, name) can only be selected in a field behind like where Albanians, two National Taiwan Normal University, she responds : always have. . . Depressed, wait-ing Could it not? Select * from t Where (id||name) in (Select id||name From t Group by id||name Having count (*), "1) John What is the language used upstairs ah? | | What is the role of the Arab symbols? ? This problem is more difficult 阿~~ Wait-ing Shen has yet to resolve it, I go top Select b.*, a.AGE, a.WEIGHT from (select ID, NAME, count (*) from Group D by ID NAME Having Count (*), "1) b, where D as a b.ID=a.ID (+) and b.Name=a.Name (+) Try : : A.* SQL> select from a test, the test b where a.id=b.id and a.name=b.name and a.rowid<>b.rowid; ID NAME AGE WEIGHT ---------- ---------- -------------------- -------------------- 1 a d s A b c 1 Suppose Xd ds ds 2 2 Suppose Xd ds sds SQL> select * from test; ID NAME AGE WEIGHT ---------- ---------- -------------------- -------------------- A b c 1 1 a d s 2 Suppose Xd ds sds Suppose Xd ds ds 2 4 a ds ds | | Connecting symbols. John --> Thank you, Azerbaijan, this method should be I try [ Closed window ]