do a loop on below equation . Varying n from 1 to required
(2n) + (2n-1)
Label record is standard means it will use disk files. But
tape files can have standard label too.
If the label record is omitted it should be a the tape file
without any begin and end blocks on the tape.
We can increment the count for each reading of record in a file.
count = count + 1
is there identity column in this table, for example, if
there is a column indexnum int(supposed start from 1), you
can use the Update Table Set XXX=XXX where indexnum < 101
Dead lock time out erro occurs in the following case:
If two or more programs acquired exclusive lock on the
data,which may be needed for other programs without that
data which can not proceed further.
Solution: You can roll back current unit of work for one of
the programs after preset time interval for deadlocks and
terminate that program.
No, It will not work. SELECT DISTINCT works only for single
DISTINCT can be applied multiple times only when you want
to apply aggregate functions such as COUNT, AVG & SUM.
SELECT COUNT(EMPNO)/COUNT(DISTINCT(WORKDEPT)), COUNT
we cannot write when disp is share
CAN BE INCREMENT OR DECREMENT USING ARITHMETIC OPERATIONS
CAN BE INCREMENT OR DECREMENT USING SET VERB
One can use Inner Join to get data from two tables.