What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 60654In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 21652How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)
5 9082A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?
8 10075Post New Infosys SQL Server Interview Questions
Can you work under pressure and dead lines?
Will you be happy to work in night shifts or over the weekends?
How do I use the function keys on my laptop?
Can I host wordpress on my own server?
WHY U APPLIED ONLY ONE UNIVERSITY CAN I HAVE MORE THAN ONE I-20
Tell me what do you understand about responsive websites?
What is column in ms excel?
What tags do you need to add within the asp:datagrid tags to bind columns manually? Give an example.
How to rename an index?
What are the different technologies involved in establishing wan links?
What is the advantages of using clearcase tool instead of sharepoint with regards storing files?
What is hover app?
Incoming line 11kv And transformer capacity is 2500kva. Consumption load is 1300A. Then fuse capacity is 11kv line.
Define Dynamic push down optmization?
why we use log files in QTP?