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
- 14453 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / u.radha
select distinct student_name from student;
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What exactly do quotation marks around the table name do?
What is an oracle database table?
What is the data pump export utility?
What is varray?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
can u plz provide me oca sql dumps please i need them
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is memory advisor in Oracle?
How to end the current transaction in oracle?
What is the usage of analyze command in oracle?
What is execute immediate in oracle?
What is where clause in oracle?
Explain oracle 12c new features for developers?
