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
- 17092 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / u.radha
SELECT STUD_NAME,COUNT(*) FROM STUDENT GROUP BY STUD_NAME
HAVING COUNT(*) > 1
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is the fastest query method to fetch data from the table?
How a tablespace is related to data files?
How do we get field detail of a table?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the oracle implicit cursor?
How remove data files before opening a database?
What is the usage of merge statement?
How to define a record variable to store a table row?
what are steps for interface? where is exchange rate defined in which table?
Why does Oracle not permit the use of PCTUSED with indexes?
How many file formats are supported to export data?
What is key preserved table?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is bulk load in oracle?
How to check the server version in oracle?
