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
- 14434 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is a dead lock in oracle?
Where is the export dump file located?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
Write a syntax for update query in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to invoke the data pump import utility?
What is oracle data type?
What are a cluster and non-cluster index?
What are the differences between date and timestamp in oracle?
Will you be able to store pictures in the database?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Explain the types of exception?
What is tns name?
How to write numeric literals in oracle?
