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
- 16943 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 data file?
Whether any commands are used for months calculation? If so, what are they?
How a tablespace is related to data files?
How will you differentiate between varchar & varchar2?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is the difference between postgresql and oracle?
Explain what are clusters?
How to define a variable to match a table column data type?
Explain integrity constraint?
How to connect to the server with user account: sys?
How do I know if oracle is installed on windows?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How do we get field details of a table?
How do we display rows from the table without duplicates?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
