What is the difference between SYNONYM and ALIAS?6 19296
What information can you find in SYSIBM.SYSLINKS table?1 6277
What is the difference between IN subselects and EXISTS subselect?1 7824
What technique is used to retrieve data from more than one table in a single SQL statement?9 8601
what is the maximum number of tables that can be joined ?8 12881
What are simple, segmented and partitioned table spaces ?1 9830
What is the difference between group by and order by?2 11336
What is sqlcode -811?7 57659
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.7 51888
why should we bind the DB2 program . What if we did not BIND a BD2 program ??9 26699
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 7233
Bind concepts in DB2 cobol10 22306
what is the difference between normal select query and currosor2 13174
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 6686
what is dynamic cursor?gives syntax for this?1 2877
In what script is snap$ created? In what script is the scott/tiger schema created?
Describe the function and utility of the most difficult SAS macro that you have written?
how can I make the copper get white bye any salt or acit?
Write a command to find all of the files which have been accessed within the last 30 days. Output should be stored in a file “December.files”
HOW TO calculate steam velocity on boiler o/l ?
Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?
what is flow of project?
can anyone provide me the Balance Sheet Items & P & L Items with Accounting Heads with Accounting codes?
DESCRIBE WHY MANAGEMANT EDUCATION YOU WANT TO PURSUE???????/
I AM FROM ELECTRICAL ENGINEERING ? I AM ASPIRING FOR "BHEL".HOW I HAVE TO PREPARE .ON WHICH TOPICS TO BE CONCENTRATE MORE.PLEASE GIVE FULL DETAILS OF WRITTEN EXAM.
How does FDDI node determine whether it can send asynchronous traffic and synchronous traffic
Please let me know the depreciation rates.... com 2011-12.... Vechicle - Computer - Furniture - Tel instrument -
What are the types of disk array used in SAN?
Hi SD Gurus, What is the difference between the Consignment Fill up (CF) & Consignment Pick up (CP) with relation to Sales Document Types, item Categories & Schedule line Categories? Also give definition of both Consignment Fill Up & Consignment Pick Up along with detailed explanation in relation to its configuration& customization steps along with Business Scenarios? Explain in detail about how do you copy an existing Sales Document type CF & CP, how do you name it ( Plz give Name key from your real time data)and what are the customizations you have done for your client? Do provide the document flow for both the Document Types CF & CP? Please provide as many real time data examples as many as possible with reference to your client/ Project? I have interview within 1-2 days? So, I request you to provide solutions to above question as early as possible? Your timely help would be greatly appreciated? Thanks in advance Regards
How to implement dphibernate to activate lazy loading in Flex with java ?thanx in advance!