How can I get the count of a GROUP BY SQL query? This means I has displayed group by house number. I want the count of this group of house numbers. Answer This is only a guess, this would count number of voters per House No., like: And if you want to include the YadiNo (whatever does this mean), you
Tag: sql
php/mysql: get data from one table, convert and insert in another table
Ok I will try to explain, (I am Portuguese lol). I have a Database where I have the fallowing MySQL: Database: ad Table: notebooks Fields: ID, tag, so, lastlogon, lastlogh My ldap query gets data from ldap server (active directory) and stores it in my MySQL database (ad/notebooks). I get tag which is tag numb…
DropDownList has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value
I keep getting the above error in the title line and it makes no sense, because I am using a sample table with only 5 records and each record has a value as per the drop down menu. This is my code used to declare the drop down list. I have joined two tables in my SQL data source to
Time difference between swipe-in and swipe-out for employees; allow for tailgating and exit on different day
This is continuation of/added complexity to the question: sql query – Get the difference time between swipe in – Swipe out for employee. We have similar swipe-in/out data, but additional constraints. Sample source data: The data comes in the above format but the desired output and input data incre…
Order By Date ASC with Spring Data
I try to make an application with Spring-Data-JPA on a table in order by ASC but it gives me an error: Invalid derived query! No property asc found for type java.util.Calendar Why ? List …
Backup a single table with its data from a database in sql server 2008
I want to get a backup of a single table with its data from a database in SQL Server using a script. How can I do that? Answer There are many ways you can take back of table. BCP (BULK COPY PROGRAM) Generate Table Script with data Make a copy of table using SELECT INTO, example here SAVE Table Data
Duplicate check using SELECT or rely on unique index?
Using SQL Server 2012. I want to insert unique strings into a table. I always want to return the row ID of the unique string. Now, this can be accomplished in two ways. Which solution is the best? This is the table in question: Solution 1: SELECT first to check if the string exists. If it does, return its ID.
Get number of employees who worked in more than one department with SQL query
I’m trying to figure out a query which show the number (amount) of employees who worked in more than 1 departments. Here the table name and fields: Employee(id_employee, employee_name, salary) Department(id_dept, dept_name, budget) Department_Employee(id_employee, id_dept, workhours_percentage) Suppose …
Oracle: Single multicolumn index or two single column indexes
I have table create table1( column1 number(10, column2 number(10), column3 number(10) ); column1 is Primary Key column2 and column3 is Foreign key I have created unique constraint on 2 …
Drop Several Tables at Once
I have some tables that I need to drop on a regular basis. The names of the tables sometimes change but the table names always begin with ‘db_comp_temp’. Is it possible to write some SQL that will in effect do something like: Thanks in advance, Answer No, there is no wildcard support in DDL. Or: Y…