Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table with the columns below as
Emp_ID Address_ID Address_Line City Country
-------- --------- ----------- ------ ---------
Q: Display the Emp_ID's those having more than one
Address_ID
- 7 Answers
- 8717 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shashi
select Emp_ID from table_name groupe by Emp_ID
having count(Address_ID )>1;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is port in oracle? how is it related to database application.
What is snapshot is too old? Give and example for better understand.
Use of an integrity constraint is better to validate data. Explain
Will you be able to store pictures in the database?explain.
State and explain the different types of data models?
Can you have more than one content canvas view attached with a window ?
How to rename a column in an existing table?
How to experiment a data lock in oracle?
What is the minimum client footprint required to connect c# to an oracle database?
How to create id with auto_increment on oracle?
What is blob data type in oracle?
what is the difference between functional dependecy and multilevel dependency?
How to estimate disk space needed for an export job?
What is the relation of a user account and a schema?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
