How to remove duplicate records
Sql Interview Questions
2,208 sql interview questions shared by candidates
find top 10 employee by using DENSE RANK.? SELECT 10 FROM DUAL MINUS SELECT 5 FROM DUAL.? Query for deleting duplicate rows. Write a procedure to store all the data from a table to a collection table.
What's the types of joints?How to create a table?
Q1: What are triggers? Q2: what are joins and state its types? Q3: What is View?Can we insert, update, delete on view? Q4: What are Aggregate functions?
Calculate the no of exp of the employees from the joining date from table?
Q: If at 5pm on Friday you received a request from stakeholder for report etc how would you deal with this.
What is Insert in DBMS.
What is lazy writer.?
how to find out 1st highest salary
Out of n records the query to pickup 3 to 8 records from a table?
Viewing 21 - 30 interview questions