What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 60543In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 21562How 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 9006A 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 9974Post New Infosys SQL Server Interview Questions
How can you find your id on a system?
what is the difference between "Rotary bypass isolation switch and Normal bypass switch" pls share indepth techs?
which is the bet long term & basic to advanced available course for asp.net in hydrabad plz reply me t my email address also thanking you sm.chishty@gmail.com
What is the state if the RED LED is glowing on DVxx card What is the state if the YELLOW LED is glowing on DVxx card What is the state if the GREEN LED is glowing on DVxx card Which frequency band DVDC is used Which frequency band DVGA is used
what are different types of heading are supported by html?
Usually customers won’t give all the requirements. How will you manage & collect all the necessary information?
Name the grade of forged steel use for manufacturing of master connecting rod and why to prefer that grade.
How optimize sql query with multiple joins in sql server?
What is meant by a valid server name directive?
What is difference between innerhtml and value?
What do you mean by aggregate and scalar functions in dbms?
What are gradients in Canvas used for? What are their different types?
What is capacity requirement planning?
How will you ensure your consistency and efficiency in meeting deadlines once you join the organization?
What is csrf protection in laravel?