Can you select any column in a Group by query even if that column is not groupable?e.g. Select Dept, Empno, Ave(salary) From T1 Group by DeptCan we select empno in the above query?

yuvaevergreen

 Profile Answers by yuvaevergreen Questions by yuvaevergreen

• Apr 11th, 2010

Yes Empno should be included in the query.

Anand_Hakke

 Profile Answers by Anand_Hakke Questions by Anand_Hakke

• Aug 7th, 2009

No, It is not posssible to select ungrouped column in a query.

Answer Question  Select Best Answer

dyury

 Profile Answers by dyury Questions by dyury

• Mar 8th, 2010

We can use scrollable cursor ( with DB2 V8 and higher).FETCH FIRST ROWSET STARTING AT ABSOLUTE N FROM CURSOR1 FOR 1 ROW.

kaviarasu

• Jun 23rd, 2006

SELECT  *  FROM  TABLE_NAME  AAWHERE  5 = (SELECT  COUNT (FIRST_FIELD) FROM TABLE_NAME                      WHERE FIRST_FIELD <= AA.FIRST_FIELD )WITH UR;

Answer Question  Select Best Answer

Cecil

• Jan 19th, 2017

As far as a knowledge of coding, you will need to learn how to modify existing JCL code. You also should have a basic knowledge of programming to the point that you can learn to modify the data you m...

Wayne Heckman

• Feb 7th, 2016

Not anything close to testing client server applications.

Answer Question  Select Best Answer

When will occur -811 abend? how will u resolve the -811 abend?

rasheeed17

 Profile Answers by rasheeed17 Questions by rasheeed17

• Jan 19th, 2012

- You will get -811 abend when your SQL query returns more than one record. - COBOL do not have ability to handle more than one db2 record at a time. - You must USE CURSOR If your query returns mor...

6983manish

 Profile Answers by 6983manish Questions by 6983manish

• Nov 12th, 2011

If the need is to get any of the row qualified for the predicates given , you can use "Fetch First 1 Row Only" with your select query.

OR

If you are interested all the data qualified for the query , there is no option except the use of Cursors.

Answer Question  Select Best Answer

The Cursor can be Declared in Working storage sectionLinkage sectionInput-Output section.
Working storage section

Sid

• May 6th, 2016

It can be declared either in working storage section or in procedure division.

Anandakumar Raju

• Apr 28th, 2016

Cursor can be declared either working storage section or procedure division. It should be declared before open cursor statement if we are declaring in procedure division.

Answer Question  Select Best Answer

madhavan

• Mar 10th, 2014

SELECT * FROM Table_Name order by column_name desc Fetch first 5 rows only;

Mohit

• May 28th, 2012

There is nothing called "fetch last n records only" in db2...

You can use select col1 from table1 order by col1 desc fetch first 5 records only

Answer Question  Select Best Answer

Anand

• Oct 25th, 2016

Yes, GROUP BY must come before ORDER BY if both are used

Papadon

• Jul 26th, 2016

Yes, We can.

Code
 

Answer Question  Select Best Answer

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

Check Pending is when you have data added to the table using either insert or LOAD utility which violate table check constraints. The IBM DB2 LOAD UTILITY has ENFORCE CONSTRAINTS and similar options w...

Mohit

• May 28th, 2012

SET INTEGRITY Option....please read IBM libraries before using this.

Answer Question  Select Best Answer

i ) Unique Index can be created only on Primary Key. ii) Query will execute faster if predicates are applied on Indexed column. 1 Both are True2 i) is only True3 ii) is Only True4 Neither is True

Gilbert

• Mar 3rd, 2015

Both are true

Rishu

• Aug 9th, 2014

3 ii) is Only True

Answer Question  Select Best Answer

Yaswanth

• Jul 12th, 2021

Dbrm or package not found in olan

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar Questions by Mandar Dindorkar

• Jul 27th, 2012

-805 will never occur if a DBRM is directly bound to a PLAN. -805 occurs when 1) Source Program is changed and per-compiled and new LOAD Module created as a result of change is used at Run time, but ...

Answer Question  Select Best Answer

Table1 has 6 rows and Table2 has 6 SELECT * FROM Table1, Table2; a.6b.12c.36d.720e.Cannot sayrows.36

abhay

• Jul 18th, 2016

The ans is 36, I have tested it.

Devu

• Feb 26th, 2015

36

Answer Question  Select Best Answer