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.
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
How to retrieve data from an explicit cursor?
How to change program global area (pga) in oracle?
How to use "for" statements in oracle?
What privilege is needed for a user to connect to oracle server?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to start your 10g xe server?
What are the common oracle dba tasks?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What are the general rules on data consistency?
What is sharded cluster?
How to export several tables together?
Explain oracle’s server parameter file.
What is an index associated with a constraint?
How would you best determine why your MVIEW couldnt FAST REFRESH?