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

[@mugeshm4740]

This is not a fresher interview 😑✨..

[@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]

select max(sal) from emp where sal

[@smgyt4550]

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

[@karthick2523]

Thank you it's very useful🎉

[@kenywest-ex7de]

he is good guy & interviewer as well

[@osoriomatucurane9511]

Awesome interview and feedback! I have learnt a lot!

[@anithaadaka8738]

Very useful for freshers

[@Ananthapu_ramu_abbai]

Hi

[@SabaMirza-q6w]

Thanks with this i realized on which stage i am?

[@isanju_rai]

Dense_rank function is wrong re check ✔️

[@nagasai7681]

Keep posting

[@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 ;

[@Payroking]

❤❤❤❤

[@rahultalwar4847]

nice interview got good knowledge

[@hardiknaik9124]

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

[@hardiknaik9124]

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.

[@paterugopi3189]

Great👍👍👍

[@tomlee126]

when asked "what",..just list the "whats" dont try explaining all "whats" in detail. only when asked

[@killer82906]

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

[@KingJagguYT]

Go for Naukri

[@somusagumale6440]

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

[@jagannathramdasbarde6528]

Pls share application support interview

[@aniquekhan5640]

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

[@chinnayoutuber5094]

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

[@supriyayerbage]

Nice

[@Payroking]

😮

[@madhudaddy]

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

[@devi_drawings]

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

[@nitinsalunke2578]

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]

These guys applying for freshers

[@technicalsyntax]

Great interview

[@ashutoshkhedkar519]

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

[@Lozzymee]

Ye fresher interview hai😮😂?

[@neetusingh4765]

Very freshers

[@bhavya1732]

Did he got selected or what

[@harishealukapally403]

This is only mock interview

[@mahiroman3554]

😂😂😂

[@ankurghosh2884]

Useless

[@devi_drawings]

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]

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]

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

[@jhansiranimodugumudi8380]

Nice