SQL - Read For Learn

“You tried to execute a query that does not include the specified aggregate function”

The error is because fName is included in the SELECT list, but is not included in a GROUP BY clause and is not part of an aggregate function (Count(), Min(), Max(), Sum(), etc.) You can fix that problem by including fName in a GROUP BY. But then you will face the same issue with surname. So put both in the GROUP BY: Note I used Count(*) where you wanted SUM(orders.quantity). However, orders isn’t included … Read more

What is the difference between a stored procedure and a view?

A view represents a virtual table. You can join multiple tables in a view and use the view to present the data as if the data were coming from a single table. A stored procedure uses parameters to do a function… whether it is updating and inserting data, or returning single values or data sets. … Read more

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I tried the following code different ways, like by taking out the while or the if, but when I put both together (if and while), I always get the error at the end… ERROR: FIXED by changing how I declared the variable “a” to: *Notice that here, the significant change is to use VARCHAR2 instead … Read more

how to remove time from datetime

The field DATE in the database has the following format: I would like to remove the time from the date and return the date like this:

How do you force mysql LIKE to be case sensitive?

201 Use LIKE BINARY:

SQL selecting rows by most recent date with two unique columns

You can use a GROUP BY to group items by type and id. Then you can use the MAX() Aggregate function to get the most recent service month. The below returns a result set with ChargeId, ChargeType, and MostRecentServiceMonth

Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)

Try using a format file since your data file only has 4 columns. Otherwise, try OPENROWSET or use a staging table. myTestFormatFiles.Fmt may look like: 9.0 4 1 SQLINT 0 3 “,” 1 StudentNo “” 2 SQLCHAR 0 100 “,” 2 FirstName SQL_Latin1_General_CP1_CI_AS 3 SQLCHAR 0 100 “,” 3 LastName SQL_Latin1_General_CP1_CI_AS 4 SQLINT 0 4 … Read more