Invoices


SELECT     * 
FROM INVOICES


This only works in SQL Server as there is no (nolock) feature in Access

SELECT     * 
FROM INVOICES (nolock)


This works in both SQL Server and Access becuase Quantity is a numerical field

SELECT     * 
FROM INVOICES
WHERE Quantity BETWEEN 50 AND 60


This works in both SQL Server and Access

SELECT     Country 
      ,COUNT(Country)
FROM INVOICES
GROUP BY Country
HAVING Country = 'Denmark'
ORDER BY Country ASC


This works in both SQL Server and Access

SELECT     * 
FROM INVOICES I
INNER JOIN CUSTOMERS
ON Customers.CustomerID = I.CustomerID
WHERE I.City = 'Lyon'




© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext