Another – ERROR: column “da2.dependency_device_name” must appear in the GROUP BY clause or be used in an aggregate function

I am attempting to aggregate dependency_device_name into one string, “Dependency List”. Here is the error:

ERROR: column “da2.dependency_device_name” must appear in the GROUP BY clause or be used in an aggregate function.

Here is the sql. I have added the field to the group by and still have the same error message:

Select xy1."Dependency Count", xy1."Dependency List", ag2.report_type_name, xy1.dependent_device_name from view_affinitygroup_v2 ag2  left join  (     Select    da2.dependency_device_name,           da2.effective_to,    da2.dependent_device_name,    da2.dependent_device_fk,    sum(1) "Dependency Count",   string_agg(da2.dependency_device_name,', ') "Dependency List"   from     view_deviceaffinity_v2 da2         ) as  xy1       on xy1.dependent_device_fk = ag2.primary_device_fk and xy1.effective_to is null     where ag2.report_type_id = 1    group by      da2.dependency_device_name,      ag2.report_type_name,      xy1.dependent_device_name,      xy1.effective_to 

How to make edit menu (ellipsis icon) be in another column?

I created a Contacts list and the ellipsis icon is badged to my Last Name column. It currently sits to the right of my Last Name column.

I want to either make the ellipsis icon column independent by itself, or make it appear to the left of my Last Name column instead.

I looked at the .aspx file in SharePoint Designer and in the <ViewFields> section, the element that is responsible for Last Names column is:

<FieldRef Name="LinkTitle"/>

I’ve tried looking up previous threads like this one:

Make another column linked to item with edit menu in sharepoint 2013 list

But they don’t appear to line up with my code. I was not able to find linkToItem="TRUE"

Getting the column names of a table by brute force blind SQL injection

Is there a way of getting the column names of a table by brute force blind SQL injection in MySQL. so the query would be:

select column_name from information_schema.columns WHERE table_name = ‘tablename’ and *column names first letter = "a"*  

so if the first column name of that table does not begin with ‘a’, it would return an error if it did begin with ‘a’ it wouldn’t. and do the same for the second, third letters and so on working through the alphabet. Is this possible? or is there a more efficient way maybe? Thanks

Column names in each table must be unique. Column name ‘LastName’ in table ‘HumanCustomers’ is specified more than once

After update my model and add data annotation.

then use add-migration and update-database command get below error:

Column names in each table must be unique. Column name ‘LastName’ in table ‘HumanCustomers’ is specified more than once.

But LastName field once used.

for guid:

HumanCustomer Class:

public class HumanCustomer     {         public int Id { get; set; }         public int UserId { get; set; }         [Required]         [MinLength(2)]         [MaxLength(20)]         public string Name         {             get => Name;             set             {                 value.TrimAndReduce();             }         }         [Required]         [MinLength(2)]         [MaxLength(20)]         public string LastName         {             get => LastName;             set             {                 value = value.TrimAndReduce();             }         }         [NotMapped]         public string FullName         {             get { return Name + LastName; }          }         [Required(AllowEmptyStrings = true)]         public int GenderId { get; set; }         public string Address { get; set; }         public string Phone { get; set; }         [DataType(DataType.EmailAddress)]         [EmailAddress]         public string Email { get; set; }         public DateTime BirthDate { get; set; }         public int IdentityTypeId { get; set; }         public string IdentityCode { get; set; }            [Required]         [ForeignKey("UserId")]         public virtual User User { get; set; }           [Required]         [ForeignKey("IdentityTypeId")]         public virtual IdentityType IdentityType { get; set; }         [Required]         [ForeignKey("GenderId")]         public virtual Gender Gender { get; set; }     } 

and migration:

 protected override void Up(MigrationBuilder migrationBuilder)         {             migrationBuilder.AddColumn<string>(                 name: "LastName",                 table: "HumanCustomers",                 maxLength: 20,                 nullable: false,                 defaultValue: "");              migrationBuilder.AddColumn<string>(                 name: "Name",                 table: "HumanCustomers",                 maxLength: 20,                 nullable: false,                 defaultValue: "");         }          protected override void Down(MigrationBuilder migrationBuilder)         {             migrationBuilder.DropColumn(                 name: "LastName",                 table: "HumanCustomers");              migrationBuilder.DropColumn(                 name: "Name",                 table: "HumanCustomers");         } 

Load data from pipe delimited flat file to hive table ignoring first column, first row and last row [on hold]

I have a set of files in the below format

For example-

H|| D|12|canada| D|432| T|4

I want to load only the data part into a hive table ignoring the Header row, trailer row and also the first column having ‘D’

I know we can use table set properties to remove header part, is there anything similar to remove trailer and first column as well?

How to convert multi-value answers into single column in Google Forms’ response sheet?

I have a Google form that asks for Name and up to 3 Score. The data is dumped into a sheet like this

enter image description here

But that data is not very convenient. I want to have the data like this…

enter image description here

Can I do that by adding a new sheet to the workbook, and some kind of LOOKUP formula? Or can I change the settings on the FORM to write up to 3 rows per submit?