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
- 17478 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What are the differences between number and binary_float in oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
what is pragma?
what is the uses of cusor
does the query needs a hint to access a materialized view?
Why do we need integrity constraints in a database?
How to define Data Block size ?
What is a cursor and what are the steps need to be taken?
How to fetch the row which has the max value for a column?
What is max rowid in oracle?
What are the different type of Segments ?
What is hot backup and logical backup?
Oracle General 
