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.
Answer Posted / abc
SELECT name FROM student_table
GROUP BY name
HAVING ( COUNT(name) > 1 );
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is private procedure oracle?
Please explain oracle data types with examples?
What is difference between sid and service name in oracle?
How to rollback the current transaction in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
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
Give the advantages and disadvantages of clusters.
What is user managed backup in Oracle?
Can you drop an index associated with a unique or primary key constraint?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to create a new tablespace in oracle?
What is truncate oracle?
What do you understand by a database object? Can you list a few of them?
What are the advantages of oracle?