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
- 16940 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / abc
SELECT name FROM student_table
GROUP BY name
HAVING ( COUNT(name) > 1 );
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you mean by a deadlock?
What are the roles of dba?
what is the scenario where you take the database to NoArchivelog mode?
How to check the oracle tns settings?
What is the difference between 10g OEM and 11g OEM?
How to shutdown your 10g xe server from command line?
How to use subqueries with the in operator using oracle?
What is index in Oracle?
How to create id with auto_increment on oracle?
How to update a table row with a record?
Explain an integrity constrains?
What do you mean by merge in oracle and how can you merge two tables?
How to retrieve data from an cursor to a record?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
