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
- 16938 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / venkat
SELECT COUNT(NAME_FIELD_NAME)AS NOMBER_OF_OCCURENCE FROM
STUDENT WHERE NUMBER_OF_OCCURANCE >1;
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
Is primary key indexed by default in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to fetch the row which has the max value for a column?
What happens to the current transaction if the session is ended?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What happens if you use a wrong connect identifier?
Can you assign multiple query result rows to a variable?
Explain how are indexes update?
What is the difference between online and offline backups?
Differentiate between pre-select and pre-query?
How to name query output columns in oracle?
What is a subquery in oracle?
How do we create privileges in oracle?
What is not equal to in oracle?
