What is the difference between SYNONYM and ALIAS?6 24212
What information can you find in SYSIBM.SYSLINKS table?1 7670
What is the difference between IN subselects and EXISTS subselect?1 9322
What technique is used to retrieve data from more than one table in a single SQL statement?9 11422
what is the maximum number of tables that can be joined ?8 16109
What are simple, segmented and partitioned table spaces ?1 11872
What is the difference between group by and order by?2 12799
What is sqlcode -811?7 67955
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.7 63712
why should we bind the DB2 program . What if we did not BIND a BD2 program ??9 30897
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 29 9925
Bind concepts in DB2 cobol10 25889
what is the difference between normal select query and currosor2 15433
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic2 8178
what is dynamic cursor?gives syntax for this?1 3943
Explain about login shell?
What does requestmapping annotation do?
How to prepare HSD statements in tally
how to configure mq?
What is hidden property in angular 2?
Where is run exe located in windows 7?
What is node js and how does it work?
What is a set in c++?
dear sir please provide what question will be asked in bank it officer interview
What is an audit process?
What are the available primary index types in teradata.
We have job which is running as batch. It takes atleast 06 hours to complete tht job. But I wanna do tht job with in 3 hours?
What is the disease caused by cryptosporidium parvum?
Discuss the security levels which are assigned to users?
Explain property binding or one way binding in angular js?