-
-
-
-
How to write a query to retrieve only the months from certain given duration.
I will be getting this duration from the dual table. Provide query for this.Like for example, if suppose I am going to get value from the month of 01-Jan-2006 to 31-Apr-2007 then My result should be only 4 months like Jan, Feb, Mar, Apr.Btu not the whole dates. Only four rows has to be retrieved. This should be retrieved from the dual table but not from other tables.
-
-
How many null value a unique key constraint can have?
I think there can be only one null value for a unique key constraint but some say there can be more than one null value.
-
-
-
-
table is also there "phone" with phoneno as a field but table is empty.now i want the result into table2.
got it, Right!
Let me know if u have any questions.
thanks.
dev
">Hi all,thank u for ur answers.and i have an adjustment in this question.actually data is not present in a table, it's there in some file.For eg. "Data" is the file, it contains information: 2489078905,2345678909 and so on...table is also there "phone" with phoneno as a field but table is empty.now i want the result into table2.got it, Right!Let me know if u have any questions.thanks.dev
-
-
-
-
-