if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
4 6565i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
3 5958Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
2 3451Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
1 5178how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
1 5144Post New UST DB2 Interview Questions
Why is harmonic mean used to calculate f1 score and not the arithmetic mean?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How to produce such kind of file?
Distinguish between actual and formal arguments.
What restrictions are placed on method overriding in java programming?
What is the server name for sql management studio?
if a 3phase 100kva distribution transformer , 400 v,50 hz, 4-wire system is loaded at 160 k.w mostly 1-phase Lighting & Airconditioning split a.c load what will be the net effect on the power system in terms of voltage, powerfactor, current , efficiency of xformer
What are the applications of precipitation reactions?
What is dtd in hibernate?
What should a root element of an xaml document contain?
How the GATE rank calculated?and whats the importance of GATE SCORE?And how it calculated?
Process of the settlement cycle?
What do you mean by “type inference” in scala?
How to create plugin for wordpress?
What will happen if we on 200kvr capacitor bank(11kv in bus)If there is low load on transformer (1.5 mva 33/11 kv)