Search In
Joins
There are different type of joins in SQL
1.Inner Join-Return all the values if there is a match in both the table.
2.Outer join
-left outer join-Return all the values from left table and the values matched from the right table.
-right oute
Subqueries are generally similar to Normal queries in databases like -
They may return one column
They may return more column
They may return single rows
They may return multiple rows
Or it can be any of combination from above.
SubQueries are
In Java, the "==" operator is used to compare references. When we use the “==” operator in Java it compares 2 objects, it checks whether the two objects refer to the same place in memory or not.
Example:
String str1 = new String("abc");
String st
Hello Guys/Gals,
I went to a 4 day C programming course in which I learned using windows. Now I'm using Xcode on my own MAC. I'm trying to practice some of the things I learned but having some small issues with Xcode. I wrote this C program to prom
# include <stdio.h>
# define NO_OF_CHARS 256
bool areAnagram(char *str1, char *str2) //function checks whether two strings are anagrams.
{
// Create 2 count arrays and initialize all values as 0
int count1[NO_OF_CHARS] = {0};
int
Hello Reader! All of us must have designed a code to print pyramid or some other pattern of asterisk using C, C++. Here is a simple program to print the different asterisk(stars) patterns in PHP. A pattern of stars is a way of arranging these in some
Readonly keyword
Readonly: Readonly is a keyword which when used with a variable then the value of that variable can only be changed either at runtime or at the time of the instance initialization. The value is assigned to these variable when they
Displaying running totals is a common request, and there is no straightforward way to do so in SQL.
The idea for using SQL to display running totals similar to that for displaying rank: first do a self-join, then, list out the result
using System ;
class MyVector3{
public float X {get; set;}
public float Y {get; set;}
public float Z {get; set;}
public MyVector3(float x, float y, float z){
X = x ;
Y = y ;
Z = z ;
}
public static MyVector3 operator+ (MyVector3 vec
Array is used to keep collection of objects. Array in ruby can have any type of objects together. Using array in ruby:
>> a = []
>> arr = [1, 0, 7]
>> arr[2] # => 7
>> arr.size # => 3
>> arr = ["string", 5, 0.8,
