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
- 17102 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
What happens if the update subquery returns multiple rows?
Explain the use of full option in exp command.
How to use "while" statements in oracle?
How do I connect to oracle database?
How does one get the view definition of fixed views/tables?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
How many categories of data types?
What is private procedure oracle?
How to find out what oracle odbc drivers are installed?
How to use fetch statement in a loop?
What are the different types of trigger and explain its various uses and functions?
Explain the features of oracle?
How to define a specific record type?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is oracle open database communication (odbc)?
