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.
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 to find no of saturdays in a month using single sql ?
how to get second highest sal of emp table
What are the attributes that are found in a cursor?
What are the differences between primary key and unique key?
Explain the use of rows option in exp command.
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
How can we find out the duplicate values in an oracle table?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Explain the truncate in oracle?