SQL FOR TESTING

  SQL Server Query Interview Questions with Answers SQL Server DATEADD() Function 1) Write a Query to display the date after 15 days?   SELECT DATEADD(dd, 15,getdate()) 2) Write a Query to display the date after 12 months? SELECT DATEADD(mm, 2, getdate()) 2) Write a Query to display the date before 15 days?   SELECT DATEADD(dd, -15, getdate()) SQL Server DATEDIFF() Function 3) Write a Query to display employee details along with exp? SELECT * DATEDIFF(yy, doj, getdate()) AS ‘Exp’ FROM employee 4) Write a Query to display employee details who is working in ECE department & who his having more than 3 years of exp? SELECT * DATEDIFF(yy, doj, getdate()) AS ‘Exp’ FROM employee WHERE DATEDIFF(yy, doj, getdate())>3 AND dept_name=’ECE’ 5) Write a Query to display employee details along with age? SELECT * DATEDIFF(yy, dob, getdate()) AS ‘Age’ FROM employee 6) Write a Query to display employee details whose age >18? SELECT * DATEDIFF(yy, dob, getdate()) AS ‘Age’ FROM em...

    1. ORACLE : DESCRIBE table; OR DESC table; OUTPUT: Name Null Type FIRST_NAME CHAR(20) LAST_NAME CHAR(20) PHONE NUMBER(10) 2. SQL SERVER EXEC sp_columns Table TABLE_QUALIFIER | Employee TABLE_OWNER | HRDB TABLE_NAME | Emp COLUMN_NAME | Salary DATA_TYPE | -4 TYPE_NAME | Salary PRECISION | 2147483647 LENGTH | 2147483647 SCALE | NULL RADIX | NULL NULLABLE | 1 REMARKS | NULL COLUMN_DEF | NULL SQL_DATA_TYPE | -4 SQL_DATETIME_SUB | NULL CHAR_OCTET_LENGTH | 2147483647 ORDINAL_POSITION | 4 IS_NULLABLE | YES SS_DATA_TYPE | 23 (1 row affected)

  SQL order of execution is: "FM WG HAVING SOL" 1: from 2: where 3: group by 4: having 5: select 6:order by 7:limit eg: Write an SQL Query find number of Employees with GENDERaccording to gender whose DOB is between '01/01/1996' to '31/12/1999' select count(*) as NO OF EMPLYEES,Gender from Employees WHERE DOB BETWEEN '01/01/1996' AND '31/12/1999' GROUP BY GENDER STEPS: 1.FROM  CHOOSE AND JOIN TABLE TO GET BASE DATA Here "EMPLOYEES" is Selected. 2.WHERE  Filters the DATA WHERE DOB BETWEEN '01/01/1996' AND '31/12/1999' 3.GROUP BY AGGREGATES THE BASE DATA GROUP BY GENDER MALE,FEMALE MALE: 1 FEMALE: 3,4 4.HAVING FILTERS THE AGGREGATED DATA EG: HAVING  EMPID < 100 5.SELECT : RETURNS FINAL DATA 6.ORDER BY : SORTS THE FINAL DATA EG ORDER BY NO OF EMPLYEES ASC 7.LIMIT : LIMIT THE RETURN DATA TO ROW COUNT select count(*) as NO OF EMPLYEES,Gender from Employees WHERE DOB BETWEEN '01/01/1996' AND '31/12/1999' L...