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
- 17460 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 |
Where do we use decode and case statements?
why pl sql doesn't support retrieving multiple records
How to use "startup" command to start default instance?
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
How to generate query output in html format?
How to get a list of all background sessions in the database?
Give syntax for SQL and ORACLE joins.
What is difference between a formal and an actual parameter?
What is java oracle used for?
why dont we assign not null constraint as table level constraint.
How to use "out" parameter properly?
What is a nvl function?
Oracle General 
