Given a SELECT statement that has a GROUP BY clause.The HAVING clause uses the same syntax as which other clause?A. WHEREB. UNIONC. SUBQUERYD. ORDER BY

smonroy

 Profile Answers by smonroy Questions by smonroy

• Sep 28th, 2011

It's like WHERE clause but "HAVING" It is more commun to use with GROUP BY

Ksudhir_Kumar

 Profile Answers by Ksudhir_Kumar Questions by Ksudhir_Kumar

• Sep 5th, 2010

Having clause is used filter data which is retrieve by group by clause.for example: if you try to use having to filter data instead of where clause then it fires error.the style of query is:- 1...

Answer Question  Select Best Answer

Do we need to give level number in sequence order? Why?

toton_tcs

 Profile Answers by toton_tcs Questions by toton_tcs

• Mar 9th, 2010

More higher number of level having less position in the level hierarchy.That's why It should be in the increasing manner. 01 date 03 day pic 9(2). 03 month pic 9(2). 03 year pic 9(4...

Answer Question  Select Best Answer

Kathir

• Jul 1st, 2017

Static Call: Sub programs compiled version of code is embedded with main program so if compile sub program with modified changes then main program is also being compiled. Dynamic Call:Sub programs ve...

Maria

• Jun 16th, 2015

We can identify whether the call is static or dynamic by seeing the CALL structure. Static Call: we refer the program name in the CALL statement. e.g. CALL PGM1 Dynamic call : we use one WS variabl...

Answer Question  Select Best Answer

toton_tcs

 Profile Answers by toton_tcs Questions by toton_tcs

• Mar 4th, 2010

YES  It's possible..but the level number should be same.

ragavprasanna

 Profile Answers by ragavprasanna Questions by ragavprasanna

• Aug 31st, 2008

Yes, it is possible, redefines means using (sharing) the same memory space. It is not necessary to share variables having same picture clause.

Answer Question  Select Best Answer