SQL ,Data Warehouse and Testing Concepts

Problem Statement:- Order_Tbl has four columns namely ORDER_ID, PRODUCT_ID, QUANTITY and PRICE. ORDER_Tbl Table                             ...

Problem Statement:- Order_Tbl has four columns namely ORDER_DAY, ORDER_ID, PRODUCT_ID, QUANTITY and PRICE Order_Tbl Table                   ...

Problem Statement:- Order_Tbl has four columns namely ORDER_DAY, ORDER_ID, PRODUCT_ID, QUANTITY, and PRICE Order_Tbl Table      ...

SCENARIO:    We have EMP_DETAILS table which contains employee details such as EMPID, GENDER,EMAILID and DEPT_ID columns. We want to d...

   Consider below two tables Table_First and Table_Second for answering the below questions. Basically you will be able to check your JOIN...

   Consider below Employee table and Department table for answering the questions:- SELECT * FROM EMP_DETAILS; SELECT * FROM DEPT_D...

SCENARIO: Table Employee_Details has Gender column. In this Gender column M should be updated with F and F should be updated with M. ...

SCENARIO:   We have table EMPLOYEE_INFO  which contains Employee information. We want to display all characters before '@' in E...

SCENARIO:   We have table COUNTRY_INFO  which contains country names. Country_name field has some junk characters. Those junk characters...

SCENARIO:   We have table EMPLOYEE_INFO    which contains Employee information. We want the output table should display NAME field and i...

SQL- Scenario Based Questions PART- 4 SCENARIO: Suppose there is a table which contains a column NetBalance which has both negative a...

Q. How to get distinct rows from SQL table without using DISTINCT keyword . CREATE TABLE ProductDetail ( ProductID Int ,   ProductName...

   Consider below Employee table and Department table for answering the questions:- Employee Table: EMPLOYEE TABLE Departm...