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
- 14432 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 dont we assign not null constraint as table level constraint.
what is IDE,DMV in sql server?
How to test null values?
In which language oracle has been developed?
How to rename an index in oracle?
what is the difference between functional dependecy and multilevel dependency?
What is different types of joins?
Explain the use of rows option in imp command.
How to get execution statistics reports on query statements?
How can you use check constraints for self referential integrity?
What is clustered table in Oracle?
What is oracle and what are its different editions?
How to execute a stored program unit?
How do I reset a sequence in oracle?
How to define an anonymous procedure with variables?
