Thanks a lot, problem was – I can’t create xsd with above xml, please help me to create it. Answers were – use another version, it was created and then deleted, encoding is wrong. I found the answer myself, I needed just headings which are usually put above the xml. That much. solved Validating xml … Read more
for remove duplicate records, use this query DELETE n1 FROM news n1, news n2 WHERE n1.id < n2.id AND n1.itemId = n2.itemId AND n1.tag_id = n2.tag_id AND n1.tag_id IS NOT NULL solved remove duplicate records – mysql
Both. In some rows, t2.number is number and in others t3.number is number. The result of the union all in a single result set. The result set doesn’t know the origin of the values in any particular column (although you could include another column with this information). 3 solved Selecting the right column
you should surround your variable with quotes ”, simply change to WHERE `id` = ‘” .$id.”‘”) As suggested you can’t use WHERE in INSERT queries but you should use an UPDATE query so you syntax should look like this: $result = mysql_query(“UPDATE cafes set deal=”$deal” WHERE `id` = ‘” .$id.”‘”) or die(mysql_error()); Then I would … Read more
Using max(ship_num) is a good idea, but you should use the analytic version (with an OVER clause). select * from ( select t.*, max(ship_num) over (partition by order_id) as orders_max_ship_num from table1 t1 ) with_max where ship_num = orders_max_ship_num order by order_id, item_code; 0 solved Joins and/or Sub queries or Ranking functions
First check datatypes: SELECT ‘0.458441’, system_type_name FROM sys.dm_exec_describe_first_result_set(N’SELECT 0.458441′, NULL, 0) UNION ALL SELECT ‘10.000000’, system_type_name FROM sys.dm_exec_describe_first_result_set(N’SELECT 10.000000′, NULL, 0) UNION ALL SELECT ‘5.000000’, system_type_name FROM sys.dm_exec_describe_first_result_set(N’SELECT 5.000000′, NULL, 0); ╔═══════════╦══════════════════╗ ║ value ║ system_type_name ║ ╠═══════════╬══════════════════╣ ║ 0.458441 ║ numeric(6,6) ║ ║ 10.000000 ║ numeric(8,6) ║ ║ 5.000000 ║ numeric(7,6) ║ ╚═══════════╩══════════════════╝ Query … Read more
Compiled queries use special syntax that the database understands. They usually add placeholders for parameters such as in: select * from applicant where name = ? select * from applicant where name = :name The exact syntax depends on the specific technology: JDBC, ODBC, etc. Now, once those queries are sent to the database (without … Read more
You are doing a query and storing a result resource in $result1, then fetching all the rows in a loop that you echo out, then immediately trying to fetch it again. Once you fetch all the results, you can’t fetch them again. Well you can, using mysql_data_seek, but it’s really inefficient and wasteful to do … Read more
You can achieve that in single query but you need to have some foreign key in other tables. Here check the code below. SELECT b.*, ba.*, bs.* FROM tbl_books as b FULL OUTER JOIN tbl_books_author as ba ON ba.book_id=b.id FULL OUTER JOIN tbl_books_subject as bs ON bs.book_id=b.id WHERE b.title LIKE ‘law’ OR ba.author LIKE ‘law’ … Read more
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘,,,)’ at line 1 [closed] solved You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use … Read more
how about this query : select top 3 Package_Title, DurationInDays,Package_Image_1, Adult_Price , STUFF((Select themes.theme + ‘,’ From package_theme inner join themes on themeid = package_theme.theme Where package_theme.package = packages.Package_ID FOR XML PATH(”)),1,1,”) As theme from packages inner join rates on rates.package = packages.Package_ID 5 solved sql server select statement for 3 tables using join [closed]
Put an “AND” in your join clause instead of joining twice. SELECT Users.* FROM Users INNER JOIN ActiveJobs DEP ON Users.Department = DEP.Department AND Users.JobTitle = DEP.JobTitle 0 solved SELECT a subset of records from Table A that match two columns in table B
You appear to have an extra quote in your query. The following should work for you: vSQl := ‘select toValueText(a.code, a.descr) from (select currency_code code, des1 descr ‘||’from sy_curr_code ) a ‘; Note the quote before your closing parenthesis has been removed. 1 solved Receive an unexpected symbol error in my PLSQL query [closed]
Here’s how I’d go about it – I wrote it in SQL because I’m WAY better at that than I am at LINQ, but converting from one to the other should be straightforward: select t1.id , t1.value from table1 as t1 inner join table2 as t21 on t21.idTable1 = t1.id and t21.number = 1 inner … Read more
You probably want to use the binary, varbinary or varbinary(max) data type. Of course, you have to convert the (JPEG) image to a byte array first in order to store it in the database. Depending on the programming language of your choice this can be easy or hard. Not sure if you can read files … Read more