Basic Clause; simple and advance filter

Question 1

Write a query to display first_name in uppercase, last_name in lower case, EACH word first character of Job_ID into uppercase and rest in lowercase from employees

Answer 1

Select Upper(First_name), lower(last_name), initcap(Job_ID) from employees;

Question 2

Write a query to display all records from employees table, only those records whose first_name starts with ‘A’

Answer 2

Select * from employees
where first_name like ‘A%’;

Question 3

Write a query to display all records from employees table; only those records whose last_name ends with ‘a’;

Answer 3

select * from employees where last_name like ‘%A’;

Question 4

Write a query to display all records from employees table, only those records whose first_name having two ‘o’.

Answer 4

Select * from employees where first_name like ‘%oo%’;

Question 5

Write a query to display all records from employees table; only those records whose first_name not start with ‘S’;

Answer 5

Select * from employees
where first_name not like ‘S%’;

Question 6

Write a query to display all records from employees table, only those records whose last_name start with ‘A’ and ends ‘s’

Answer 6

Select * from employees
where last_name like ‘A%s’;

Question 7

Write a query to display all records from employees table, only those records whose first_name having ‘a’ at second position OR last_name having ‘s’ at second last position

Answer 7

Select * from employees
where first_name like ‘a%’ OR Last_name like ‘%s’;

Question 8

Write a query to remove left side space from the given string ‘ vaannii’

Answer 8

select LTrim (‘ Vaaniii’) from dual;

Question 9

Write a query to remove @ from left side from given string ‘@@@vaanii’

Answer 9

select Ltrim( ‘@@@Vaanii’,’@’) from dual;

Question 10

Write a query to remove @ from both side from given string

Answer 10

select trim ( ‘@’ from ‘@@@Vaanii@@@’) from dual;

Question 11

Write a Query to format the below string which should be 10 character long; if it is having 10 character then add ‘$’ on right side ‘Vaannii’

Answer 11

Select rpad(‘Vaanii’,10,’$’) from dual;

Question 12

Write a query to display all records from employees table, only show those records whose department_ID is not in 10,20,30

Answer 12

Select * from employees where department_ID NOT in (10,20,30) ;