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
- 13629 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
How to download oracle database 10g xe?
query optmization techniques and quwry analyser+projects+ppts
What are the different types of record groups in oracle? Explain each of them
What are the ways tablespaces can be managed and how do they differ?
Explain the use of grant option in exp command.
does the query needs a hint to access a materialized view?
What is raw datatype?
Explain joins in oracle?
How to get a list of all background sessions in the database?
How to list all user accounts in oracle?
Write a syntax for update query in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Compare and contrast between sql and sql server and explain its various functions?
How to insert a new row into a table in oracle?
