SQL query column functions

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
srini1508
Member
Posts: 14
Joined: Fri Sep 30, 2011 4:37 pm

SQL query column functions

Post by srini1508 » Tue Oct 11, 2011 3:56 pm

Hi,

I faced a interview question as belwo.

in a database i need to fetch a a record SALARY from a database SAL TABLE for a employee RAVI. but RAVI is not there in the database, so what will happen to the given SQL QUERY

select MAX(SALARY) from SAL where empname = 'RAVI'

??

pLESE LET ME KNOW

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Tue Oct 11, 2011 4:01 pm

read about the MAX function and pay special attention to the comment about empty result sets.
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

srini1508
Member
Posts: 14
Joined: Fri Sep 30, 2011 4:37 pm

Post by srini1508 » Tue Oct 11, 2011 4:06 pm

thanks for ur quick response .. i got the answer --- NULL

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others