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 / valmiki sreenivasulu
A)select sname from student group by sname;
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
How many types of database triggers exist?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How to use like conditions in oracle?
How to install oracle odbc drivers?
What is the relation of a user account and a schema in oracle?
List the various oracle database objects?
How to write date and time literals in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to list all user accounts in oracle?
List out the components of logical database structure of oracle database.
How to connect the oracle server as sysdba?
How can I get column names from a table in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
What are the arithmetic operations?
How to define an oracle sub procedure?