Tuesday, October 11, 2016

SQL interview question for stragglers

How to find out second highest salary in sql ?

Ans:Go to this link

Can we use multiple foreign key ?

Ans: Go to this link

Why we use commit ?

Ans: Go to this link

ACID means ?

Ans: Go to this link

Why group by  use in SQL and give a example ?

Ans: Group by use for select all the data in a group. Example: A shop there lots of sale .If you want find out the sale specific branch you need group by the branch .

Why order by use in SQL ?

Ans: Order by keyword sorts the results ascending and descending. For ascending it use ASC and for descending it use DSC


Define SQL SubQuery and give example?

Ans: SubQuery

Difference between union and union all?

Ans: Go to this link

what is SQL?

Ans: Go to this link

what is RDBMS?

Ans:Go to this link

Difference between unique key and primary key?

Ans: Go to this link 

what is left join?

Ans: Go to this link

Difference between cast and convert?

Ans: Go to this link

What is SQL distinct ?

Ans: Go to this link

Describe Inner join?

Ans: Inner join

What is right join?

Ans: Right join

Describe outer join and cross join?

Ans: Outer join , Cross join

what is self join give example ?

Ans: Self join

Difference between having and where ?

Ans : Go to this link

what is called store procedure?

Ans:  Store procedure

No comments:

Post a Comment