What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 63694In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 23539How 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 10901A 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 12687Post New Infosys SQL Server Interview Questions
Thumb rule of cable size(rm>30 rm)X multiplying factor=ampere
Is array a collection c#?
Explain the header data in layout set.
At which levels in the sales document can you have different incompletion procedures?
what are the direct expense of loan department in banks.
What is locking ?
What is ascii code?
What is the difference between subset ratio & information density?
What is c++ similar to?
What is use of model in laravel?
How we load the page in ASP?
Django is based on which design pattern?
What do you mean by “type inference” in scala?
What is various between twb and twbx file extensions?
In a binary data sequence, the duration of symbol 0 or 1 is 1ms. If a carrier of freq 4khz is used in ask, what is the minimum transmission bandwidth required? What is min bandwidth?