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
- 14427 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / dheer
select v_id from dup where rowid not in (select max(rowid)
from dup group by v_id);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain a data segment?
Explain the blob datatype?
Who developed oracle & when?
What suggestions do you have to reduce the network traffic?
What is an Oracle index?
How to use select statement to count the number of rows in oracle?
How to call a stored function in oracle?
In which language oracle has been developed?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
State the difference between a primary key and foreign key?
How to convert character types to numeric types?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to convert characters to numbers in oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is an oracle?
