relational database - alternative to intersect operation in mysql -

-

when try below code got error

"error 1064 (42000): have error in sql syntax; check manual corresponds mysql server version right syntax use near 'intersect select sc1.section_identifier,sc2."

and searched in internet , found new fact mysql doesn't support intersect operation. how can fix code having same function 'intersect'. please me!!

select g1.section_identifier, g2.section_identifier grade_report g1, grade_report g2 g1.student_number=g2.student_number ,   g1.section_identifier<g2.section_identifier intersect select sc1.section_identifier,sc2.section_identifier section sc1, section sc2 sc1.course_number=sc2.course_number ,      sc1.section_identifier<sc2.section_identifier;


Comments

Post a Comment

Popular posts from this blog

php - Autoloader issue not returning Class -

-
problem? bootloader (autoloader) not seem working properly, or i'm missing something. here simplified code. the code below returns class "skeleton" not exist. on index.php file. index.php <?php include 'bootloader.php'; use skeleton\html\loginheader; $tool = new skeleton/html/loginheader(); bootloader.php <?php function boot($classname) { $filename = ''; $namespace = ''; // sets include path "src" directory $includepath = dirname(__file__).directory_separator.'src'; if (false !== ($lastnspos = strripos($classname, '\\'))) { $namespace = substr($classname, 0, $lastnspos); $classname = substr($classname, $lastnspos + 1); $filename = str_replace('\\', directory_separator, $namespace) . directory_separator; } $filename .= str_replace('_', directory_separator, $classname) . '.php'...
Read more

C++ Program To Find Smallest and Largest Number In Array -

-
beginner in c++ here , learning arrays. program below supposed return smallest , largest number in array using 2 separate functions. 1 largest , 1 smallest number. however, returning 0 time function lastlowestindex , unsure may doing wrong. could ever kindly advice , show me incorrect in function , can done correct returns correct value? not seeing and/or understanding incorrect. thank , time in advance!!! #include <iostream> #include <cstdlib> int lastlargestindex(int [], int); int lastlowestindex(int [], int ); using namespace std; int main() { const int n = 15; int arr[n] = {5,198,76,9,4,2,15,8,21,34,99,3,6,13,61}; int location; //int location2; location = lastlargestindex( arr, n ); cout << "the last largest number is:" << location << endl; location = lastlowestindex(arr, n); cout << "the last smallest number is:" << location << endl; // std::system ("pause"); ...
Read more

java - How to put two numbers separated by a space into two different arrays -

-
i have 2 number inputs 1010 212 i want put these 2 different arrays ([1 0 1 0] , [2 1 2]) this code import java.io.*; import java.util.*; public class solution { public static void main(string[] args) { int array[] = new int[8]; int array2[] = new int[8]; int = 0; scanner getnumber = new scanner(system.in); { array[i] = getnumber.nextint(); i++; } while(getnumber.hasnextint()); system.out.println(arrays.tostring(array)); } } but output [1010, 212, 0, 0, 0, 0, 0, 0] (i put 8 generic array length because java compiler forced initialize each array) you need store numbers first initialize arrays based on length of number. can length turning string. once left number , empty array, can split integer array of digits number of ways. int[] array, array2; scanner in = new scanner(system.in); int a, b; = in.nextint(); b = in.nextint(); array = new int[integer.tostring(a...
Read more