Companywise Interview Questions
GeoMaps Interview Questions
SQL:
- Difference between primary key and unique key
- Difference between COALESCE and ISNULL
- which is faster subquery or inner join?
- magic tables
- if you have search functionality and your query is slow. what steps you will follow to optimise your query?
- can we call stored procedure from Trigger or Trigger from stored procedure?
- I have table column VARCHAR(10) and I am passing 15 Char to it. What will happen?
- Write Query:
select rows which are not common in two tables
- what is use of partition by?
- What is CTE Table? can we access it anywhere in stored procedure after declared?
- select any numeric record from table (1,2,3,1A,2B,3c)
- select alternate records
- create copy of a table
- what should be the best data type for primary key?
Post a Comment
0 Comments