## [Solved] How should I calculate the average speed by road segment for multiple segments?

When averaging speeds, the harmonic mean is in need. The straight forward AVG() approach is wrong, the arithmetic mean yields the wrong result for average velocity. There is no predefined function for the harmonic mean, but it could be achieved with this query: SELECT segment, COUNT(*)/SUM(1e0/speed) AS avg_speed FROM T GROUP BY segment SQL Fiddle … Read more

## [Solved] Want to the check the records existing in the date range in sql server [closed]

Try this with myTable ( numberid, startDate, endDate ) as( select numberid, CONVERT(DATETIME,startDate), CONVERT(DATETIME,endDate) from ( values (4405598510,’2011-08-06 00:00:00′,NULL), (2418680054,’2011-08-06 00:00:00′,’2011-12-28 00:00:00′), (4405598510,’2011-08-06 00:00:00′,NULL), (1810168034,’2011-08-06 00:00:00′,NULL), (6849266569,’2011-08-06 00:00:00′,’2014-09-02 00:00:00′), (2682265222,’2011-08-09 00:58:00′,’2012-09-20 00:00:00′), (6253123963,’2011-08-09 00:00:00′,’2011-07-01 00:00:00′), (8276745680,’2011-08-10 00:00:00′,’2014-06-27 00:00:00′), (3873103800,’2011-08-10 00:00:00′,’2013-07-16 00:00:00′), (3703761027,’2011-08-06 00:00:00′,NULL), (1810168034,’2011-08-06 00:00:00′,NULL) ) [ ] (numberid,startDate,endDate) ) select Numberid, startDate, endDate, case … Read more

## [Solved] dynamic query to column to row in mysql [closed]

Solution for your problem is to use PIVOT Try to look at this: Convert Rows to columns using ‘Pivot’ in SQL Server 4 solved dynamic query to column to row in mysql [closed]

## [Solved] mysql – I dont understand what this means, can anyone explain each line of the script to me? [closed]

It creates a new table “students” in the database if it doesn’t exist already. Each row from ” student_id” to “Reg_date” represent one column in the table. NOT NULL next to a column means you can’t leave it empty when you insert data. “student_id” is a primary key, and is automatically incremented for each entry … Read more

## [Solved] Nested SQL statements for Oracle [closed]

You don’t need to nest. You need to join. You’ll probably need something like this, although I would need the exact table structure to be sure. But you’ll get the general idea. select b.TITLE, a.LASTNAME, i.UNITSONHAND from BOOK b inner join AUTHOR a on a.AUTHORID = b.AUTHORID inner join INVENTORY i on i.BOOKID = b.BOOKID … Read more

## [Solved] Need SQL Script

If the possible values are only ‘Breachend’ and ‘Not Breached’, you can GROUP BY incident_number and get the minimum as ‘Breached’ < ‘Not Breached’. SELECT incident_number, min(has_breached) has_breached FROM elbat GROUP BY incident_number; 1 solved Need SQL Script

## [Solved] Solve the query using join?

You only have one table so there is nothing to join on. In your current query you have no need to use a sub query .Your query should be : select name from session1 where id <>21 To find “I have a table session1 and need to find only new entries who logged in with … Read more

## [Solved] Incorrect syntax near the keyword ‘FROM’. No clue [closed]

You have two froms in the query. FROM FROM table1 –change this solved Incorrect syntax near the keyword ‘FROM’. No clue [closed]

## [Solved] Database login failed [closed]

You are using integrated security, which means that the user who is running your program needs to have the relevant access permissions on the database. If you are running the program interactively (e.g., it is not a service), then YOU need the access permissions, that is, the account that you used to log into Windows … Read more

## [Solved] How do I update a value in C# and SQL Server? [closed]

You didn’t tell what is wrong exactly but I see a few things wrong in your code. You should always use parameterized queries. This kind of string concatenations are open for SQL Injection attacks. I assume your Scor and ID columns are numeric, not character. That’s why you should not use single quotes with it. … Read more

## [Solved] Joining queries

SELECT a.id, a.name, a.player_count, a.rating, AVG(p.total_people_count) AS `average` FROM p_alliances a INNER JOIN p_players p ON (p.alliance_id = a.id) GROUP BY a.id ORDER BY a.rating DESC, a.player_count DESC, a.id ASC LIMIT %s,%s If there could be 0 players you might want to change INNER JOIN to LEFT JOIN, but it may impact performance in mysql. … Read more

## [Solved] Microsoft SQL Server: how to put together these three tables? [closed]

Join the tables, concatenate the strings and use LIKE to look for the “certain text”. SELECT p.path + ‘\’ + d.filename FROM documents d INNER JOIN documentsinprojects dp ON dp.documentid = d.documentid INNER JOIN projects p ON p.projectid = dp.projectid WHERE p.path LIKE ‘%certain text%’ AND d.filename LIKE ‘%certain text%’; 4 solved Microsoft SQL Server: … Read more

## [Solved] Sql code to create the Mirror image of the string in Oracle sql [closed]

If “mirror” is reversed text use: SELECT REVERSE(‘my_text’) FROM dual; EDIT: SqlFiddleDemo SELECT t ,REVERSE(t) AS Mirror1 ,TRANSLATE(t, ‘abcdefghijklmnopqrstuvwxyz’,N’ɐqɔpǝɟbɥıظʞןɯuodbɹsʇnʌʍxʎz’) AS Mirror2 ,TRANSLATE(REVERSE(t), ‘abcdefghijklmnopqrstuvwxyz’,N’ɐqɔpǝɟbɥıظʞןɯuodbɹsʇnʌʍxʎz’) AS Mirror3 FROM tab; 2 solved Sql code to create the Mirror image of the string in Oracle sql [closed]

## [Solved] android.database.sqlite.SQLiteException: near “)”: syntax error (code 1): [closed]

change your query to this , you’re missing some spaces and also you must remove the last comma from the query @Override public void onCreate(SQLiteDatabase db) { String query = “CREATE TABLE ” + TABLE_PRODUCTS + “(” + COLUMN_ID + ” INTEGER PRIMARY KEY AUTOINCREMENT, ” + COLUMN_PRODUCTNAME + ” TEXT, ” + COLUMN_VENUE + … Read more

## [Solved] Types of SQL joins

You’re getting no relevant answers on Google because the answer is (d): None. The closest kinds of joins are left-join and right-join. 3 solved Types of SQL joins