What is the difference between SYNONYM and ALIAS?6 20005
What information can you find in SYSIBM.SYSLINKS table?1 6459
What is the difference between IN subselects and EXISTS subselect?1 8080
What technique is used to retrieve data from more than one table in a single SQL statement?9 9000
what is the maximum number of tables that can be joined ?8 13423
What are simple, segmented and partitioned table spaces ?1 10209
What is the difference between group by and order by?2 11643
What is sqlcode -811?7 59565
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.7 53498
why should we bind the DB2 program . What if we did not BIND a BD2 program ??9 27299
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 7642
Bind concepts in DB2 cobol10 22858
what is the difference between normal select query and currosor2 13560
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 6888
what is dynamic cursor?gives syntax for this?1 3048
Distinguish my and local?
How to Get the windows directory?
Explain security types in asp.net?
I have a report it taking so much time how can I rectify
What is the working of centrifugal switch in 1phase induction motor
What is a weighted graph?
what are all the things will consider while doing sensitivity analysis?
Is there any course for billing available in Mumbai? If yes then please mail me the details..
how create a pivot tables, pivot charts in ms. excel
What is the meaning of ?
Short Answer on __________Event
How do you include a module in your python file?
How would you create properties by using class Builder Wizard?
What is typical size for a swap partition under a linux system?
In database testing, how to do the data load testing?