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 / 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
How can I get column names from a table in oracle?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What do you mean by merge in oracle and how can you merge two tables?
Explain constraining triggers.
How many types of auditing in Oracle?
Explain oracle data types with examples?
What is a synonym? What are its various types?
Use of an integrity constraint is better to validate data. Explain
When do we use group by clause in a sql query?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Define oracle database
What are a query and state the different types of queries and their uses?
What do you mean by merge in oracle?
Explain the use of rows option in exp command.
What is Redo Log Buffer in Oracle?