What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 63513In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 23418How 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 10747A 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 12497Post New Infosys SQL Server Interview Questions
PLEASE SEND ME NTPC RELATED INFORMATION LIKE WHICH TOPICS HAV MORE SCOPE,BOOKS TO READ,CUT OFF...PLEASE.mail at thiru.1203@gmail.com
Explain about the leakage class of the control valves
HiFriends can you all pls help me in providin me with the answers 1 In which table we store Leads? 2 Types of issues in support?
Why blue prism is much preferred over other rpa tools?
What does meta-store means in hive?
Is swift a good first language?
Which scripting language used by quicktest professional (qtp)?
In database testing, what do we need to check normally?
Is there an exemption for schools and institutions of higher education from either the FLSA or the Department's overtime regulations governing white collar workers?
What are the functional areas?
Explain maskable and non maskable interrupts?
What is the treasury stock method?
What kind of Neutral CT can be placed in 11/0.433KV transformer to be used and what are its specification?
What is a canvas?
What is jvm heap?