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
- 16615 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / seethal
select stu_name from(select stu_name,count(stu_name) sc from
stu_table group by stu_name)where sc > 1;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to pass a cursor variable to a procedure?
What is the maximum limit on the number of columns in a table?
Describe varray?
How to invoke the data pump export utility?
What are the various types of snapshots ?
Can I create users through internet explorer in oracle 10g?
When do you get a .pll extension in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the restrictions in a oracle read only transaction?
What is Library Cache in Oracle?
is there a tool to trace queries, like profiler for sql server?
What is the usage of control file in oracle?
List the parts of a database trigger.
Explain coalesce function?
How to create a stored program unit?
