1
Answer

Can anyone explain that c# code, please ?

Photo of ahmed sami

ahmed sami

12y
1.1k
1
        double[] msolve(double[][] m)
        {
            int i, j, k;
            int n = m.Length;
            double factor = 0;
            double precision = 1e9;
            double[] m1 = new double[n];
            double[][] m2 = new double[n][];
            for (i = 0; i < n; i++)
            {
                m2[i] = new double[m[i].Length];
                for (j = 0; j < m[i].Length; j++)
                {
                    m2[i][j] = m[i][j];
                }
            }
            for (k = 1; k < n; k++) for (i = k; i < n; i++)
                {
                    factor = m2[i][k - 1] / m2[k - 1][k - 1];
                    for (j = 0; j <= n; j++) m2[i][j] -= m2[k - 1][j] * factor;
                }
            for (i = n - 1; i >= 0; i--)
            {
                m1[i] = m2[i][n];
                for (j = n - 1; j > i; j--) m1[i] -= m2[i][j] * m1[j];
                m1[i] /= m2[i][i];
                m1[i] = Math.Round(m1[i] * precision) / precision;
            }
            return m1;//matrix(n, 1, m1);
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            var d = new double[][] { new double[] { 1,1,2,8}, new double[] { -1,-2,3,1},new               double []{3,-7,4,10}};
            var sl = msolve(d);
        }

Answers (1)

1
Photo of Rahul Prajapat
NA 2.1k 191.7k 9y
Hello @Vilas try this query:
 
SELECT * FROM (SELECT * FROM dbo.Table_1 t UNION SELECT * FROM dbo.Table_2 t)AS Student WHERE Student.roll='E-153'
 
I hope this will help you.
Accepted
1
Photo of Karthikeyan K
NA 6.4k 488.1k 9y
SQL> CREATE TABLE SAMPLE(ID NUMBER,NAME VARCHAR(20));

Table created.

SQL> CREATE TABLE SAMPLE1(ID NUMBER,NAME VARCHAR(20));

Table created.

SQL> INSERT INTO SAMPLE(ID,NAME) VALUES('&ID','&NAME');
Enter value for id: 1
Enter value for name: KARTHIK
old 1: INSERT INTO SAMPLE(ID,NAME) VALUES('&ID','&NAME')
new 1: INSERT INTO SAMPLE(ID,NAME) VALUES('1','KARTHIK')

1 row created.

SQL> /
Enter value for id: 2
Enter value for name: MITHU
old 1: INSERT INTO SAMPLE(ID,NAME) VALUES('&ID','&NAME')
new 1: INSERT INTO SAMPLE(ID,NAME) VALUES('2','MITHU')

1 row created.
SELECT ID,NAME FROM(SELECT * FROM SAMPLE UNION ALL SELECT * FROM SAMPLE1) WHERE ID=2;
SQL> INSERT INTO SAMPLE1(ID,NAME) VALUES('&ID','&NAME');
Enter value for id: 3
Enter value for name: VINITH
old 1: INSERT INTO SAMPLE1(ID,NAME) VALUES('&ID','&NAME')
new 1: INSERT INTO SAMPLE1(ID,NAME) VALUES('3','VINITH')

1 row created.

SQL> /
Enter value for id: 4
Enter value for name: MENON
old 1: INSERT INTO SAMPLE1(ID,NAME) VALUES('&ID','&NAME')
new 1: INSERT INTO SAMPLE1(ID,NAME) VALUES('4','MENON')

1 row created.

SQL> SELECT ID,NAME FROM(SELECT * FROM SAMPLE UNION ALL SELECT * FROM SAMPLE1) WHERE ID=2;

ID NAME
---------- --------------------
2 MITHU
0
Photo of Vilas Dongre
NA 383 18.7k 9y
Actually Person is the single table through which we can find but I want single query to search single record from multiple tables
0
Photo of Rajeesh Menoth
NA 24.7k 629.6k 9y
Hi,
 
A UNION will return unique results, whereas a UNION ALL will return everything including duplicates.