SQL Query Part 2

Query 1.      Case stmt example

---

 Tables                           Query                                               Result

EMP_JB		SELECT id	ANSWER
		,job	===============
ID JOB		,CASE	ID  JOB		STATUS
		WHEN  job  =  'Sales'
10 Sales		THEN  'Fire'	10	Sales	Fire
20 Clerk		ELSE  'Demote'	20	Clerk	Demote
		END  AS  STATUS
		FROM emp_jb;

Query 2. Fetch  first  "n"  rowsexample

---

 Tables                           Query                                               Result

EMP_NM			SELECT	*	ANSWER
			FROM	emp_nm	=========
ID NAME			ORDER  BY  id  DESC		ID  NAME
			FETCH  FIRST  2  ROWS  ONLY;
10 Sanders					50	Hanes
20 Pernal					20	Pernal
50 Hanes

Query 3. Column  Functions example

---

 Tables                           Query                                               Result

EMP_NM			SELECT	AVG(id)	AS  avg	ANSWER
				,MAX(name)  AS  maxn		=================
ID NAME				,COUNT(*)	AS  #rows	AVG  MAXN	#ROWS
			FROM	emp_nm;
10 Sanders						26Sanders	3
20 Pernal
50 Hanes