Search Interview Questions
| More than 3000 questions in repository.|
There are more than 900 unanswered questions.
Click here and help us by providing the answer.
Have a video suggestion.
Click Correct / Improve and please let us know.
|Interview Questions and Answers|
|Ans. DELETE FROM TABLE WHERE ROW_NUM NOT IN ( SELECT MAX(ROW_ID) FROM TABLE GROUP BY DUPLICATE_FIELD )|
DELETE FROM TABLE a WHERE ROW_ID >(SELECT MIN(ROW_ID FROM TABLE b WHERE a.DUPLICATE_FIELD=b.DUPLICATE_FIELD);
|Help us improve. Please let us know the company, where you were asked this question :|
|Like Discuss Correct / Improve   Asked in 3 Companies|
|What are Inner , Outer , Left and Right Joins in SQL ?|
|What is JDBC? Describe the steps needed to execute a SQL query using JDBC.|
| What is a self Join and give an example of a self Join ?|
What is self Join and What is it's purpose ?
|Is there any schema in mongo DB ?|
|Difference between Inner and Outer Join ?|
|What is a Cursor ?|
|What are temp tables ?|
|Does SQL allow null values ? Can we use it within Where clause ?|
|Write an SQL to find all records having all upper case alphanumeric characters in a field ?|
|Write an SQL to find all records having all numeric characters in a field ?|