|
View previous topic :: View next topic
|
| Author |
Message |
pbgunasekar
New User
Joined: 28 May 2005
Posts: 26
Location: Chennai
|
|
|
|
hello
table1 table2
eno ename eno training
112 ram 112 jcl
123 subbu 112 cobol
124 mad 124 db2
234 mental 123 java
123 cobol
write a query to select ename and eno from table1 those took trining any 2. |
|
| Back to top |
|
 |
kvivek
New User
.jpg)
Joined: 09 May 2005
Posts: 51
Location: Singapore
|
|
|
|
SELECT * FROM TABLE1 WHERE ENO IN (SELECT ENO FROM TABLE2 GROUP BY ENO HAVING COUNT(*) >= 2);
Regards,
Vivek |
|
| Back to top |
|
|
|
|
