SQL - Trigger, Stored Procedure, SQL Basics, truncate & delete HR - Joins, Multirow functions
Sql Support Interview Questions
499 sql support interview questions shared by candidates
If I knew what the cross apply operator was
Given 2 dates, return a result set that outputs a number for each week between the two. (They will ask the numbered week to be the sequential week and also the calendar week. Prepare for given start date to be start mid-week.)
I have weight machine, I put 100 KG gold on one side and 100 KG cotton on another side, which weight is heavier??
What Excel is not use as Database ? Relation between Table?
To summarize numbers from 1 to 100.
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.
difference between joins n write join query
How to remove duplicate records
Puzzle: A coin is in one of the inverted bags. First bag says 'Coin is in third bag', second says: 'There is no coin here' and third says: 'There is no coin here'. Considering one statement is true while two are false, where is the coin?
Viewing 1 - 10 interview questions