Login/RegisterCompanies
- Accenture
- Adobe
- Alcatel-Lucent
- Alten Calsoft Lab
- Amazon
- Amdocs
- Aricent
- Arris
- Broadcom Ltd
- Brocade
- CA Technologies
- Capgemini
- Cavium Networks
- CenturyLink
- Ciena
- Cisco
- Citrix
- Cognizant
- Comcast
- CSC (DXC Technology)
- Dell EMC
- Deloitte
- EFI
- Ericsson
- Extreme Network
- Genpact
- Gigamon
- Global Edge
- GlobalLogic
- Goldman Sachs
- Happiest Minds
- HCL Technologies
- Hewlett Packard Enterprise
- IDS Infotech
- Incedo
- Infinite C S
- IpInfusion
- J.P. Morgan
- Juniper Network
- L&T Technology Services
- MindTree
- MosChip Semiconductor
- NEC Technologies
- NIIT Technologies
- OLA
- One Access
- PayPal
- Paytm
- Qualcomm
- Radisys
- Redeem Software
- Reliance Jio
- Rolta India Limited
- Samsung
- Sasken
- Siemens
- Synopsys
- Tavant Technologies
- TCS
- Tech Mahindra
- Viasat
- Wipro
- XiLinx
Interview Questions and Answers :: SQL
No Discussion on this question yet!
No Tags on this question yet!
Index is a very popular method that which show clear increase or decrease in an any year financially or data wise.whereas it takes the information and converts it into the data.most randomly used.it shows the increase or decrease and analysis correct estimation of yearly or monthly by provided information.it is an automatic that which analysis n show financial position in business as current or pat previous years of concern whether it is having profit or loss.it is used in mostly used in accounts to know the business satisfactory or good.according to index method it is very helpful.
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
"select 100+null from dual"
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
        Id |
Name |
1 |
Ram,Shaym |
 2    |
Mohit,Arvind,Neelam |
How you will convert this record into rows on the basis of ids, like below:
Id |
Name |
1 |
Ram |
1 |
Shyam |
2 |
Mohit |
2 |
Arvind |
2 |
Neelam |
No Discussion on this question yet!
No Tags on this question yet!
Ex.
Id |
Name |
1 |
Ram,Shaym |
2 |
Mohit,Arvind,Neelam |
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
How many rows for inner join?
How many rows for left Join?
How many rows for Right join?
How many rows for full outer join?
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
Wite query to have output like below:
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
No Discussion on this question yet!
No Tags on this question yet!
