Presumably, you have more orders than you have employees. Hence, one employee is on many orders. When you run: select e.firstname from employees e inner join orders o on e.employeeid = o.employeeid; Then you are getting a list of all first names — so one employee name is going to be repeated, once per each … Read more
The underscore matches a single character, unless it is escaped. Try: select NODE_NAME from NODES where NODE_NAME like ‘%__SQL’ escape ‘_’ 3 solved How can I use underscores in “LIKE” conditions in Tivoli? [duplicate]
Following should work .. SELECT decadeBegin, decadeEnd, NumOfMovies FROM dbo.TableOfDecades(); solved using of functions or views in sql
You have used mysql_connect() in the update clause of the code. If your PHP version is 7 and above it will not work (will work for 5.5 and 5.6 versions but with a warning) as it is deprecated. Warning This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the … Read more
Below query should do the job. Names in the ADDED_BY column seem to be the reference for aggregation in both your columns. SELECT A.ADDED_BY, A.TOTAL_RECORDS_ADDED_BY, COUNT(B.UPDATED_BY) AS TOTAL_RECORDS_UPDATED_BY FROM (SELECT ADDED_BY, COUNT(*) AS TOTAL_RECORDS_ADDED_BY FROM YOUR_TABLE GROUP BY ADDED_BY) A LEFT JOIN YOUR_TABLE B ON A.ADDED_BY = B.UPDATED_BY GROUP BY A.ADDED_BY, A.TOTAL_RECORDS_ADDED_BY; solved SQL Query … Read more
You could use the RIGHT() part of the string filtering wher the firts is a number eg: SELECT right(my_column, LENGTH(my_column)-1) FROM my_table WHERE my_column REGEXP ‘^[0-9]’ for update (remove the number ) you could use Update my_table set my_column= right(my_column, LENGTH(my_column)-1) WHERE my_column REGEXP ‘^[0-9]’ 1 solved How to remove first letter if it is … Read more
CONVERT(CHAR(10), CONVERT(DATETIME, Created), 103) solved SQL date-format conversion ques
I guess simple CASE and GROUP BY should work select market, sum(case when type=”sell” then -amount when type=”buy” then amount end) from data group by market 2 solved Can we achieve this if yes then what will the SQL query for same
use update $sql=”update TABLENAME set GAME1 = case when GAME1 = ” then $item3 else GAME1 end, GAME2 = case when GAME2 = ” and GAME1 <> ” then $item3 else GAME2 end, GAME3 = case when GAME3 = ” and GAME1 <> ”and GAME2 <> ” then $item3 else GAME3 end WHERE ID = … Read more
You are trying to insert 5 length character(‘dfdfg’) into your 1 length column [Access] [nvarchar](1). Increase the value of your column in Table type. CREATE TYPE [dbo].[AccessLevel] AS TABLE( [RoleId] [int] NULL, [Access] [nvarchar](25) NULL, [IsDelete] [bit] NULL ) GO solved String or binary data would be truncated when using it in a stored procedure
How can I optimize a query that returns a lot of records, then order by a date field and return only the latest one? [duplicate] solved How can I optimize a query that returns a lot of records, then order by a date field and return only the latest one? [duplicate]
SELECT * FROM TableName WHERE dateColumn = CURDATE() CURDATE() returns current date with time set as 00:00:00. SQLFiddle Demo 2 solved MySQL – Most efficient way to select today’s date with time as 00:00:00 [closed]
Oracle doesn’t have a year() function. You seem to have got that syntax from a different database (like MySQL). You can use the extract() function instead: select * from MIS_PERMAL.MV_INDEX_PERFORMANCE where index_id = 1045 and EXTRACT(YEAR from PRICE_DATE) = 2014 1 solved Oracle : YEAR Keyword invalid
One way of doing this is to filter your select by using a subselect in the where clause. I did this really fast just to demonstrate: select * from manufacturer m inner join manufacturer_has_product mhp on m.manufacturer_id = m.manufacturer_id inner join product p on mhp.product_id = p.product_id where m.manufacturer_id in ( select m.manufacturer_id from manufacturer … Read more
Your data does not match your desired results. Here is what I believe you want: create table deleteme_tbl(department int, title varchar2(20), mydate date); insert into deleteme_tbl values( 1,’One’, date ‘2016-01-01′); insert into deleteme_tbl values( 1,’Two’, date ‘2016-04-01′); insert into deleteme_tbl values( 1,’three’, date ‘2016-02-02′); insert into deleteme_tbl values( 2,’five’, date ‘2016-04-04’); insert into deleteme_tbl values( … Read more