News
I'm having to hack a report together to pull data from another field in the same table. The row selection is going to be based on various elements in the above 'foreignkey' field - elements 1, 2, 4 & ...
SUBSTRING(full_name, CHARINDEX(' ', full_name) +1, LEN(full_name)) AS LastName, UPPER(LEFT(SUBSTRING(full_name, CHARINDEX(' ', full_name) +1, LEN(full_name)), 1)) AS ...
1-From the following table write a query in SQL to retrieve the total sales for each year. Filter the result set for those orders where order year is on or before 2016. Return the year part of ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback