JDBC- SQL spatio-temporal query

Any one give me a JDBC sql query for my spatio temporal query?

Trajectory table

OBJID PLACE

7 H

8 Q

9 W

10 A

7 H

8 A

1 S

2 D

4 G

7 B

3 K

7 H

3 I

7 C

i have trajectory table as shown in above. I want a spatio-temporal query using JDBC-SQL to retrieve results.

1." Find all OBJIDs that move from place H to place B"

"Find all usertrajectories that move from place H to place B"

here for example in this image objid 7 moves from H to B, hence the result should be .

output

query1

objids : 7

query2

7 trajectory is HHBHC

I want a SQL query for this.

View Answers

Ads

Advertisements

Sql Query
Sql Query Is this query work in Db2 or not ? Select * from FORUM LIMIT 2

sql query
sql query two tables are emp,loc write a query to display all the emp information whose locname not equal to bangalore

sql-jdbc
sql-jdbc how to execute select query using prepared statement

sql query
sql query hi friend, Im doing a project,in that a main id... numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me

Sql Query
Sql Query Hi M Navjeet Ghai I want to know How to Show A name(Like Navjeet Ghai And Manpreet Singh Sodhi) of employees from a employee table as N.Ghai & M.S.Sodhi by using sql query

sql query
sql query hi friend, Im doing a project,in that a main id... numbers of sids.i want to delete the sid based on the mid.for that i need sql query plz help to me

SQL Query
SQL Query Selecting the third highest salary of Employee without using any subquery? Here is a query: SELECT salary FROM employee ORDER BY salary DESC LIMIT 2,1

jdbc query
jdbc query write a query of how to print the values of any column present in database in reverse order

SQL QUERY
SQL QUERY am a having a table 'PROGRAMMER' with columns... C pascal Bhanu Sql... Pascal Sql Mahesh DBASE Cobol

upgrading sql query join
upgrading sql query join upgrading sql query join

optimize sql query
optimize sql query How to optimize sql query in mysql? Thanks

sql query
sql query SQL QUERY BROWSER declare @cout00 int declare @cout01 int declare @cout10 int declare @cout11 int declare @c1 float declare @gss float...); this is the query i have written for the table "dpscomp" - station date month

jdbc query
jdbc query hello sir I have used your simple bank application... but it show sql exception error data type mismatch in criteria expression. But I have used your complete project with My SQL database it showed the transaction

SQL query
SQL query I need to combine two tables in order to get the values. As an example we have three tables having namely usertable,job table and jobaccess table. In usertable (Userid,Empid,name,Role) details have been stored

Hibernate SQL Query/Native Query
This tutorial describes Hibernate SQL Query, which is also known as Native Query

display sql query in hibernate
display sql query in hibernate If you want to see the Hibernate generated SQL statements on console, what should we do

".txt" to sql with JDBC
".txt" to sql with JDBC how to insert ".txt" into sql result[BLOB] with JDBC

Update SQL Query Example
Update SQL Query Example Hi, I am beginner in SQL (MySQL) and trying to learn Update SQL Query with Example code. Can anyone explain me the SQL Update query with an example code? Thanks Hi, A simple example

Query regarding JSP, JDBC
Query regarding JSP, JDBC can I get the code for the question asked by me regarding JSP,JDBC

sql query search function
sql query search function i have a textbox on a form , i like a search a data in the form, when i give whatever name and id or etc..its will search and show the same form , so help me using jsp

Hibernate Native SQL Query Introduction
In this section, you will learn Hibernate Native SQL query

ModuleNotFoundError: No module named 'sql-query'
ModuleNotFoundError: No module named 'sql-query' Hi, My Python... 'sql-query' How to remove the ModuleNotFoundError: No module named 'sql... have to install padas library. You can install sql-query python with following

JDBC related query
JDBC related query How to merge two resultset of two different queries, wherein both the resultset(after query execution)gives an integer value as its column

SQL QUERY ERROR
SQL QUERY ERROR Im writing a query which shows error of INVALID CHARACTER The Query is Insert into PMST_EMP_MST(PMSNUM_EMP_ID,PMSSTR_EMP... THE FORM IS THROWING THE ERROR OF INVALID CHARACTER BUT THE SAME QUERY IS RUNNING

Ads