Answer Posted / sri
For example,u have a table called student like below.
STUD-NAME SUBJECT
--------- ------
STUD1 A
STUD2 B
STUD2 A
STUD1 A
in this structure 1 row is duplicated in 4 th. so we can
fetch the student name using the below qry.
SELECT stud-name FROM STUDENT
GROUP BY stud-name,subject
HAVING COUNT > 1.
Is This Answer Correct ? | 12 Yes | 10 No |
Post New Answer View All Answers
Is record in oracle pl sql?
What does (+) mean in sql joins?
What is native sql query?
Is sql database free?
Can we delete column in sql?
what are the join types in tsql? : Transact sql
Is ms sql is free?
how many sql dml commands are supported by 'mysql'? : Sql dba
what is the different between now() and current_date()? : Sql dba
What is sql deadlock?
Can we use ddl statements in stored procedure?
What is the difference between clustered and non-clustered indexes?
Which is better stored procedure or query?
How delete a row in sql?
Which are sql * plus commands?