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 / cheeku
select distinct NM from
(
(select name from student_tbl M where exists
(select 1 from student_tbl S where
S.name = M.name and
S.rowid <> M.rowid)
)NM;
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to drop a stored procedure in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is object data modeling?
What do you mean by a tablespace?
What privilege is needed for a user to connect to oracle server?
What is a user role in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What happens if recursive calls get out of control?
How to enter a new row into a table interactively?
What is a nested table and how is it different from a normal table?
What is an oracle database?
What are the differences between primary key and unique key?
What are the attributes of the cursor?
How do I use unicode codesets with the weblogic jdriver for oracle driver?