⟩ How we remove duplicate rows in table?
select * from employee a where rowid not in(Select min(rowid) from employee b where b.emp_id = a.emp_id)
select * from employee a where rowid not in(Select min(rowid) from employee b where b.emp_id = a.emp_id)
Explain Can a view be updated/inserted/deleted?
Explain What are the different types of SQL?
Explain some PL/SQL Exceptions?
Explain What is a Cartesian product?
Explain What is an Integrity Constraint?
Explain How do we eliminate the duplicate rows?
Explain What is meant by SORTING and GROUPING?
Explain What is the maximum number of triggers, can apply to a single table?
How to use SQL to build SQL, what is this called and give an example?
Explain What is the output of SIGN function?