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
- 14431 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 |
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
What are the differences between number and binary_float in oracle?
does the query needs a hint to access a materialized view?
How do we switch from init.ora file to asp file?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
How to find out what privileges a user currently has in oracle?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
How to bring a tablespace online?
How to pass parameters to procedures?
What is oracle instant client?
What are data pump export and import modes?
What are the advantages of Views ?
Oracle General 
