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

How do I know if oracle client is installed on windows?

1001


Explain the use of tables option in exp command.

1096


What is difference between sid and service name in oracle?

941


What are the differences between primary key and unique key?

987


What is the recommended interval at which to run statspack snapshots, and why?

2897


Why do we use bulk collect in oracle?

1043


What are the uses of Database Trigger ?

1682


What are the ansi data types supported in oracle?

933


Explain the importance of .pll extension in oracle?

985


Design database draw er diagram for a certain scenario ?

4561


Explain the blob datatype?

1056


What is null value in oracle?

1073


 What are the oracle DML commands possible through an update strategy?

1041


what is a Nested Loop join?

2080


Can you tell me how to add new column in existing views?how?How is possible?

1419