Notes

employee table 5 emp id , emp name ,sal, dept, designation
2nd table = emp id manager_name
print emp name with managers

SELECT Employee.emp_name,Managers.manager_name FROM Employee FULL OUTER JOIN Manager ON Employee.emp_ID = Managers.emp_ID;

SELECT dept, AVG(sal) FROM Employee GROUP BY dept;

Manager name , avg salary
SELECT
dEL , Trun, drop
DML DDL DDL

ALTER TABLE Employee
ADD CONSTRAINT uniq
UNIQUE(col1), UNIQUE(col2);


array 1 2 3 4 5
arr = [...arr,...arr];
let
var = f

C++ , array of strings , count of max occuring string;
string maxOcc(vector<string> &str)
{
unordered_map<string,int> m;
for(string s:str) m[s]++;
string temp = "";
int maxFreq =0; pank 4 ama 3
for(auto p : m)
{
if(p.second>maxFreq)
{
temp=p.first;
maxFreq=p.second;
}
}
return temp;
}
// 2nd highest;
string maxOcc(vector<string> &str)
{
unordered_map<string,int> m;
for(string s:str) m[s]++;
string temp = "";
int maxFreq =0; pank 4 ama 3
for(auto p : m)
{
if(p.second>maxFreq)
{
temp=p.first;
maxFreq=p.second;
}
}
m.erase(temp);
for(auto p : m)
{
if(p.second>maxFreq)
{
temp=p.first;
maxFreq=p.second;
}
}

return temp;
}
GET
POST
PUT