I'm trying to make a view. So far, I have written this: with ExpAndCheapMedicine(MostMoney, MinMoney) as ( select max(unitprice), min(unitprice) from
I would like to get the latest record for each server. Here is some example data: TimeGenerated SourceName ComputerName Message 2014-11-22
I would like to get the latest record for each server. Here is some example data: TimeGenerated SourceName ComputerName Message 2014-11-22
I have a table with a column like this that is currently live: name NVARCHAR(128) NOT NULL DEFAULT '' I am altering the column like this to make it nullable:
In data load, it seems some XML attributes mapped incorrectly and I'm now trying to correct this, but am struggling with MySQL's handling of this XML column. I
I have MSSTAMP as "timestamp with milliseconds" in Oracle, format: 1483228800000. How can I cast that milliseconds timestamp into a date format "YYYY-MM", in or
I need to convert minutes to hours, rounded off to two decimal places. I also need to display only up to two numbers after the decimal point. So if I have minut
I found some threads about the error. But all the solutions doesn't work for me. I created 2 tables a user table and one for articles. Now I want to store the
Having an issue with sqlsrv_query. This is the error I get: PHP Warning: sqlsrv_num_rows() expects parameter 1 to be resource, boolean given Here is the relev
mysqldump -t -u root -p mytestdb mytable --where=datetime LIKE '2014-09%' This is what I am doing and it returns: mysqldump: Couldn't find table: "LIKE"
How to write a query to just determine that the values in a column are unique?
I have a table with the following columns in a MySQL database [id, url] And the urls are like: http://domain1.com/images/img1.jpg I want to update all
I have 2 commands and need both of them executed correctly or none of them executed. So I think I need a transaction, but I don't know how to use it correctly.
I have a table where all columns are auto-populated whenever an insertion happens: CREATE TABLE … ( ItemID INT NOT NULL IDENTITY(…
I'm having the following SQL DB: DB name: films DB fields: id, title, release_year, country, duration, language, certification, gross, budget I'm trying to
Using Postgres, I'm trying to use AUTO_INCREMENT to number my primary key automatically in SQL. However, it gives me an error. CREATE TABLE Staff ( ID
The Point: I want to be able to create a directory on the filesystem through a non-sysadmin SQL user. I'm creating a web front-end for a deployment script whi
I have a simple query in PostgreSQL which is ok when I run it without any query parameters : select date_trunc('week', action_time),count(*) from event
Even though I am removing and trying to drop table, I get error, ALTER TABLE [dbo].[Table1] DROP CONSTRAINT [FK_Table1_Table2] GO DROP TABLE [dbo].[Table1] GO
Example data: +----+-------+----------+ | org_id | Name | ParentID | +----+-------+----------+ | 1 | Org1 | 2 | | 2 | Org2 | NULL | | 3 | Org3