Skip to main content

Posts

Showing posts with the label employee table in query

SQL Select Query Examples-retrieve Last five records,subquery , last letters in capital

Select Query to retrieve Last five records of the table select * from emp a where 5 >= (select count(1) from emp b where a.empno != b.empno and a.sal <= b.sal) order by a.sal desc assumptions: 1. Empno is primary key in emp table 2. 5 last records must be required based on some sorting, so i took it as salary . Select Query to get the first and last letters in capital in SQL This is sample example to use Select Query to get the first and last letters in capital in SQL. You can use with your table instead of test5. upper is function to get letter in upper case and substr method is used to get first and last letter. select upper(substr(ename,1,1)) || substr(ename,2,length(ename)-2) || upper(substr(ename,length (ename),1)) from test5; Example of subquery in sql select e.employee_id,e.first_name||' '||last_name as name,e.department_id,e.hire_date,e.manager_id,d.department_name, m.first_name||' '||m.last_name manager from employees e join department