Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17088 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
What is oracle database 10g express edition?
How to use attributes of the implicit cursor in oracle?
Give the various exception types.
What is meant by joins? List out the types of joins.
How to select some columns from a table in oracle?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What are the different oracle database objects?
What is a server parameter file in oracle?
What is a snapshot log?
Compare and contrast between sql and sql server and explain its various functions?
Please explain joins in oracle?
How to define a data field as not null?
How to assign a table row to a record variable?
What happens to the current transaction if the session is killed?
What is a private synonym?
