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
- 16630 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 |
how many types of index?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How do I know if oracle is installed on windows?
What to do if the startbd.bat failed to start the xe instance?
How to turn on or off recycle bin for the session?
How to use null as conditions in oracle?
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
how the indexes are stored in the Oracle Database?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
What happens if variable names collide with table/column names?
What is difference between cartesian join and cross join?
How to count duplicated values in a column in oracle?
Oracle General 
