Question

SALEID SID SLDATE
1001 1 01-JAN-14
1002 5 02-JAN-14
1003 4 01-FEB-14
1004 1 01-MAR-14
1005 2 01-FEB-14
1006 1 01-JUN-15

Write a query to display the number of sales that were made in the last 40 months

Answer 1

Answer:

Enter values into multiple cells using CTRL + ENTER

To quickly enter data in multiple cells, firs...............t select all of the cells. Type in the data and press CTRL + ENTER, which enters the same value in all of the selected cells. For non-contiguous cells, hold down the CTRL key and click to select each cell.M ............... ...........