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
- 17124 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / seethal
select stu_name from(select stu_name,count(stu_name) sc from
stu_table group by stu_name)where sc > 1;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a named program unit?
What is max rowid in oracle?
What are the limitations oracle database 10g xe?
What are the extensions used by oracle reports?
What are a query and state the different types of queries and their uses?
Explain self joins in oracle?
How do we represent comments in oracle?
How to establish administrator authentication to the server?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is the relation of a user account and a schema?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
Please explain oracle data types with examples?
How to rollback the current transaction in oracle?
What is a nested table and how is it different from a normal table?
