-
What is the command for below question ?
Display each employee’s last name, hire date, and salary review date, which is the first Monday
after six months of service. Label the column REVIEW. Format the dates to appear in the format
similar to “Monday, the Thirty-First of July, 2000.” -
Print with SQL Code
We have the following data hello,hello℅hi,hello hi ,hello hi% and we want to print only in order hello%hi and hello hi %.
-
Query date prompt in excel
have a MS Excel 2003 query that works tied to an excel spreadhseet. Want to know how I can have it ask in excel for a date, where the date will go into the query. Like a prompt asking through date: ???? and you can enter the date, or even if a way you could make the query search automatically enter the current date into that field would work as well. So far this is my query in sql format.SELECT PO01A.POHIS_PO_NO,...
-
-
What are the pre requisites ?
I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.
Ans