Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

Answer Posted / u.radha

select distinct student_name from student;

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is format trigger?

2058


What is an oracle data file?

1083


What is a initialization parameter file in oracle?

1020


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3315


Can I create users through internet explorer in oracle 10g?

1068


How to compare dates in oracle sql?

1088


How to export your connection information to a file?

1117


How many types of auditing in Oracle?

1020


What is BBED in Oracle?

1139


What is dual table oracle?

971


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2116


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2170


Explain what are the type of synonyms?

1097


How to use subqueries in the from clause in oracle?

1088


What is set verify off in oracle?

1078