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
- 16937 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 are the index updates?
What is recovery manager(rman) backup in Oracle?
How to shutdown your 10g xe server from command line?
How to create an initialization parameter file?
What is memory advisor in Oracle?
What is an anonymous block?
What is literal?
List out the types of joins.
6. Display the client name and order date for all orders using the traditional method.
12. Display the client name in upper case only and in lower case only.
Is primary key = unique key,not null? If yes,please explain IF No,please explain
How would you extract DDL of a table without using a GUI tool?
Oracle General 
