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
- 17123 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 the best way to do multi-row insert in oracle?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
how to see the data (in unix) using dataset in datastage?
What is oracle open database communication (odbc)?
What is oracle and what are its different editions?
what is the difference between oracle enterprise edition and oracle express edition?
What is tns name?
Does rowid change in oracle?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
How to run the anonymous block again?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Oracle General 
