Saturday, November 2, 2019

SQL Interview Question 2-4 years Experienced

1. Nth highest salary.
2. Duplicate records
3. Duplicate records delete
4. Row_number(),  Rank() and Dense_rank()
5. Lag() and Lead()
6. NVL() and NVL2()
7. Coalsce()
8.Correlated Query
9. Exists and Not exists()
10. Decode and Case.
11. Joins
12 Union and Union all
13. Instr() and substr()
14. Nullif(), ifnull() and isnull()
at No comments:
Subscribe to: Posts (Atom)

How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/lower case combinations?

  How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/...

  • Real Time Scenario
     1. Color of first and last bar same and other bar same 2. Divide the data into 2 sheets 3. Parameter Month/Quarter then in sheets Year-mont...
  • Filter/ Parameter hide based on Paramter selectoion
    Steps: 1. Create 2 Param1  and Param2. Param1 will be visible all the time the other will appear based on  selection on Param1. 2.Create bla...
  • Calculative field
    1. Some calculations comes under Diemensions and some under Measures 2. Some calculation we can change from Dimension to Measures and vice v...