+ 2

how to judge two sql queries of different forms have equivalent semantic?

Verify that two SQL query statements are equivalent - problem statement: since the same query can be written in different forms, how do you determine that two SQL query statements of different forms have equivalent semantics?

23rd Jul 2018, 12:12 PM
movis
movis - avatar
5 Antworten
+ 8
Yes , they must have. Like 'and' and '&&' produce the same result. && is just another way of representation of 'and'
27th Jul 2018, 9:54 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 7
if they give same result , then the SQL queries are same
27th Jul 2018, 6:14 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 7
This is very good question 👍👍
27th Jul 2018, 9:54 AM
Siddharth Golecha
Siddharth Golecha - avatar
+ 1
Siddharth Golecha Do they have the same ASTree(Abstract Syntax Tree) if two sql queries are same ?
27th Jul 2018, 7:16 AM
movis
movis - avatar
+ 1
use the same two querie to search a Large volume of information in general you will not see the difference but there will be a slight difference in there speed of getting the results.
5th Aug 2018, 10:05 AM
Mohamed Benhamed
Mohamed Benhamed   - avatar