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
- 17146 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 is using clause and give example?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
Can you assign multiple query result rows to a variable?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Describe the different type of Integrity Constraints supported by ORACLE ?
How to delete all rows a table in oracle?
Explain an integrity constrains?
what is the difference between no rows returned and null returned?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to create a table interactively?
What are the set operators union, union all, minus & intersect meant to do?
what is primary key?
Oracle General 
