Ddl related ddl related sql query

4. SALARY RELATED -

4.1 Salary related SQL Query

7. DDL RELATED -

7.1 DDL related SQL Query

CREATE EMPLOYEE TABLE

SELECT * FROM EMPLOYEE;

SELECT UPPER(FIRST_NAME) AS "First Name" FROM EMPLOYEE ;

Write a query for combine FIRST_NAME and LAST_NAME and display it as " FULL NAME " (also include white space between first name & last name)

SELECT FIRST_NAME +' '+ LAST_NAME AS [FULL NAME] FROM EMPLOYEE ;

Query:

SELECT * FROM EMPLOYEE WHERE FIRST_NAME like 'D%'

Query:

SELECT * FROM EMPLOYEE WHERE FIRST_NAME like '%W'

EMP_ID	FIRST_NAME	LAST_NAME	GENDER	DEPARTMENT	JOINING_DATE	SALARY
1001	ANDREW	CENCINI	MALE	IT	08-01-2014	300000
1002	STEVEN	THROPE	MALE	HR	10-02-2014	400000
1003	ANNE	HELLUNG-LARSEN	FEMALE	FINANCE	20-03-2014	500000
1004	DENE	SENA	FEMALE	ACCOUNT	30-04-2014	200000

Query:

SELECT * FROM EMPLOYEE WHERE Gender like '__le' --there are two "_"

Query:

SELECT * FROM EMPLOYEE WHERE FIRST_NAME like '%[%]%'

Query:

SELECT MAX(SALARY) FROM EMPLOYEE ;

Query:

SELECT CONVERT(VARCHAR(20),JOINING_DATE,106) FROM EMPLOYEE ;

Query:

SELECT CONVERT(VARCHAR(20),JOINING_DATE,108) FROM EMPLOYEE ;

3. DATETIME RELATED -

Datetime related SQL Query

SELECT DATEPART(YEAR,JOINING_DATE) FROM EMPLOYEE;

SELECT GETDATE()

DATEDIFF(MM,JOINING_DATE,GETDATE()) AS [Total Months] FROM EMPLOYEE;

SELECT * FROM EMPLOYEE WHERE DATEPART(YYYY,JOINING_DATE) = '2014'

SELECT * FROM EMPLOYEE WHERE JOINING_DATE BETWEEN '01-01-2014' AND '30-12-2014'