Question

Write sql query for get employee details from employee table whose first name cotains 'o'

Answer 1

Explanation:

select employee_name

from employees

where employee_name LIKE 'o%'

order by employee_name

Answer 2

SQL Queries in Oracle, Select * from EMPLOYEE where JOINING_DATE < to_date('01/01/2013','dd/mm/yyyy')

SQL Queries in SQL Server (Format - “MM/DD/YYYY”), Select * from EMPLOYEE where joining_date < '01/01/2013'

SQL Queries in MySQL (Format - “YYYY-DD-MM”), Select * from EMPLOYEE where joining_date < '2013-01-01'