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
- 16909 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / abrar yaseen
select student_name from student group by student_name
having count(OCCURANCE) > 1
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is a partition in oracle?
What are the logical operations?
What is Trigger in Oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
11. Display the client number and name and the client number and name of the person who referred that client.
What is truncate oracle?
What is a tns file?
Why does Oracle not permit the use of PCTUSED with indexes?
How to write an inner join with the where clause in oracle?
What is object data modeling?
What is the meaning of recursive hints in oracle?
How do we represent comments in oracle?
What is redo log?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
