Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to dispaly those name who is more than one in
student table?
example- in a student table sandeep kumar comes 4 times,
rakesh kumar comes 2 times, ajit kumar comes 1 times so
query will display sandeep kumar and rakesh kumar single
times.
- 11 Answers
- 17477 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / cheeku
select distinct NM from
(
(select name from student_tbl M where exists
(select 1 from student_tbl S where
S.name = M.name and
S.rowid <> M.rowid)
)NM;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is oracle and what are its different editions?
What are a cluster and non-cluster index?
Can we create trigger on materialized view in oracle?
How do I escape a reserved word in oracle?
What is a sub query? What are its various types?
what is the scenario where you take the database to NoArchivelog mode?
Explain the use of file option in exp command.
How will you differentiate between varchar & varchar2?
Explain drop constraint oracle?
query optmization techniques and quwry analyser+projects+ppts
What are the restrictions in a oracle read only transaction?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to drop a stored function?
11. Display the client number and name and the client number and name of the person who referred that client.
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
