[ad_1] 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 … Read more
[ad_1] The underscore matches a single character, unless it is escaped. Try: select NODE_NAME from NODES where NODE_NAME like ‘%__SQL’ escape ‘_’ 3 [ad_2] solved How can I use underscores in “LIKE” conditions in Tivoli? [duplicate]
[ad_1] Following should work .. SELECT decadeBegin, decadeEnd, NumOfMovies FROM dbo.TableOfDecades(); [ad_2] solved using of functions or views in sql
[ad_1] 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, … Read more
[ad_1] 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; [ad_2] solved … Read more
[ad_1] 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 [ad_2] solved How to remove first letter if … Read more
[ad_1] CONVERT(CHAR(10), CONVERT(DATETIME, Created), 103) [ad_2] solved SQL date-format conversion ques
[ad_1] 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 [ad_2] solved Can we achieve this if yes then what will the SQL query for same
[ad_1] 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
[ad_1] 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 [ad_2] solved String or binary data would be truncated when using it in a … Read more
[ad_1] 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] [ad_2] 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]
[ad_1] SELECT * FROM TableName WHERE dateColumn = CURDATE() CURDATE() returns current date with time set as 00:00:00. SQLFiddle Demo 2 [ad_2] solved MySQL – Most efficient way to select today’s date with time as 00:00:00 [closed]
[ad_1] 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 [ad_2] solved Oracle : YEAR Keyword invalid
[ad_1] 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 … Read more
[ad_1] 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 … Read more