Search:

You might be refering it some where else for sure.

Hi Rajesh,

u cant not add a unique contraint to a column of a table containing duplicate rows as Existing data is checked against the new condition before the statement succeeds.

Regards ...

Hi Jyoti,
it is not like hte way that u think. we need to initalize the varray before using it using a constructor. suppose ur initial lenght of varray is 100 n while initializing it u have given 10...

Hi i have downloaded this SQL quiz, but not able to use it. not ablke to view questions.
anybdy plz help
Regards
Risham

nothing is wrong with the query,

as already posted in the thread, anything that u giv in single quotes becomes case sensitive. may me that data stored in column is SALES TAX or Sales Tax or any...

Hi Brijesh

thats possible
bcoz 'sales tax' is a value thats stored in a column, and we can store values with spaces :)

Regards
Risham

ya i agree with suresh, there might only be mismatch in the value that u r giving in single quotes. in SQL what ever u give in single quotes become case sensitive.

hey i have downloaded this SQL package jst now but the questions are not apprearing in teh EXE, wat i m shown is only the options for the questions. anybdy please help me

OREDER BY sort your result set into asc or desc order, asc in the default.
whereas The GROUP BY keyword is used when we are selecting multiple columns from a table (or tables) and at least one...

Hi

There is difference between the two queries.

wen u use BETWEEN, both the values are inclusive in the search criteria.
whereas this is not the case in your second query.
for both the...