Fresher Mock Interview SQL | Technical Round | SQL Interview for Fresher | HR Interview

Fresher Mock Interview SQL | Technical Round | SQL Interview for Fresher | HR Interview | JAVA

Рет қаралды 100,109

Жыл бұрын

If you are interested please get in touch with this number: 9912577247 (Madhavi HR )
Hello everyone this is magneq software we are providing training & 100% placement.
Our Technologies :
JAVA,
PYTHON,
TESTING,
MAINFRAMES,
.NET,
POWER BI,
DATA SCIENCE.
Hello Guys, If you like this video please share and subscribe to magneqsoftware
Follow Us On :
Instagram: / magneqsoftw. .
Facebook: / magneqsoftware
Linkedin: / magneq-so. .
Twitter : / magneqsoftware
#magneqsoftware #training #placement #telugu #students #mockinterview #javaprogramming #teluguvideos #popularvideos #popular #jobs #javafullstackdeveloper #java

Пікірлер: 41

@mugeshm4740 9 ай бұрын

This is not a fresher interview 😑✨..

@osoriomatucurane9511 6 ай бұрын

Awesome interview and feedback! I have learnt a lot!

@karthick2523 Жыл бұрын

Thank you it's very useful🎉

@kenywest-ex7de Жыл бұрын

he is good guy & interviewer as well

@smgyt4550 10 ай бұрын

♥️♥️♥️♥️Sab maa baba ji ki jai is bharmand mein sab bharmand mein sabko acha or swast rakhiye ham sabke maa baba ji♥️♥️♥️♥️

@naveenyadavmokka Жыл бұрын

3rd Max sal (co-related sub-query) Select e1. ename , e1sal From emp as e1 Where 2=(select count (distinct e2.sal) From emp as e2 Where (e1.sal< e2.sal);

@shubhamkushwaha5381 9 ай бұрын

select max(sal) from emp where sal

@isanju_rai 7 ай бұрын

Dense_rank function is wrong re check ✔️

@nagasai7681 Жыл бұрын

Keep posting

@rahultalwar4847 11 ай бұрын

nice interview got good knowledge

@user-mp6tt3vw7z 8 ай бұрын

Thanks with this i realized on which stage i am?

@anithaadaka8738 Жыл бұрын

Very useful for freshers

@ramubare3683 Жыл бұрын

@paterugopi3189 Жыл бұрын

Great👍👍👍

@Mr3_Style3.0 Жыл бұрын

❤❤❤❤

@somusagumale6440 2 ай бұрын

Select country, max (salary) as total sales employee order by county,having county >50000;

@supriyayerbage Жыл бұрын

Nice

@jagannathramdasbarde6528 Жыл бұрын

Pls share application support interview

@sivap5241 Жыл бұрын

Delete duplicate records: Delete from tablename where rowid in (select rowid from ((select id, count(name) from table_name group by id having count(name) >1) ) ) ; 3rd maximum salary: With qury as (Select emp_id, first_name, salary, dence_rank() over(order by salary desc) as Rnk from tablename) Select * from qury where Rnk=3 ;

@technicalsyntax Жыл бұрын

Great interview

@killer82906 Жыл бұрын

How can i apply for job in this line..i have no rerfrnce yet..bt i completed my sql.

@KingJagguYT 4 ай бұрын

Go for Naukri

@Mr3_Style3.0 Жыл бұрын

😮

@hardiknaik9124 6 ай бұрын

How to handle null values in a column while inserting data we can use constraints not null

@hardiknaik9124 6 ай бұрын

For removing duplicates row from the table we can use self join, row_number() partition by windows function,then we can also use min function and add condition in where clause,we can also do it by using cte but it's long procedure and I would not recommend that.

@chinnayoutuber5094 2 күн бұрын

Asking how are you to interview was personal 😅😅😂😂

@polukasanthosh3701 Жыл бұрын

madam or sir in u r company job are there myself santhosh reddy

@aniquekhan5640 Жыл бұрын

okay so for further details Hr will contacts you😂😂 ye bhaari tha Raao 😄

@devi_drawings 6 ай бұрын

Delete Duplicate Values DELETE From Table Name Where row_id NOT IN ( SELECT MAX(row_id) From table_name GROUP BY column_name);

@nitinsalunke2578 4 ай бұрын

types of schema 1) star schema 2) semantic shema These are two answers you but I am a little confused about whether this second answer is correct or not

@saulgoodmanxd 10 ай бұрын

These guys applying for freshers

@neetusingh4765 Жыл бұрын

Very freshers

@ashutoshkhedkar519 2 ай бұрын

He's asking How are u? 😂 Is it a fresher interview

@bhavya1732 Жыл бұрын

Did he got selected or what

@harishealukapally403 Жыл бұрын

This is only mock interview

@mahiroman3554 11 ай бұрын

😂😂😂

@ankurghosh2884 2 ай бұрын

Useless

@devi_drawings 6 ай бұрын

3rd Maximum Salary SELECT * FROM ( SELECT department_id , hire_date , salary , DENSE_RANK ( ) OVER(partition by department_id order by Salary DESC) "max_salary" FROM employees ) WHERE max_salary = 3;

@madhankumar1810 11 ай бұрын

Creat a duplicate table? Syntax is Creat table # table name ( Emp_id number(5), Emp_namr varchar(20) ); Insert values in the table? Insert into # table name Values(40265,'John');

@maheshtiwari2297 9 ай бұрын

U can use insert into tbl_name followed by select * from previous_tblName.