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
What does an inner join do?
What is sql prepared statement?
What are the different operators available in sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
how is myisam table stored? : Sql dba
How do I save the results of sql query in a file?
What are inner and outer joins examples of both?
How can we make an if statement within a select statement?
What are two statement types in sql?
what are the different tables present in mysql? : Sql dba
how can you create an empty table from an existing table? : Sql dba
Which is faster union or join?
Does postgresql run on the cloud?
What are database links used for?
How do you delete duplicates in sql query using rowid?