What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 63365In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 23322How 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 10677A 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 12379Post New Infosys SQL Server Interview Questions
What is 'commit' command in perl?
Explain the difference between the neo4j graph database and mysql database?
how to get a list of indexes of an existing table? : Sql dba
what is correct accounting treatment for preliminary exps and pre-operative Expsas per AS 26? or any other applicable AS?
What is a constructor overloading in java?
How do you import payscale data from non sap to sap?
HR generalist position is a key position in advising, assisting and reporting to HR head, in such a case what are your strengths and work attitude?
write down a program to that reads the data from port 02H, count the number of 1's in the data and display the count on port 03H in 8085 microprocessor
explain the basic QA plan to co-op with development plan for effective delivery of the product
Why should we hire you over other candidates?
Explain what are conformed dimensions?
What are the uses of sysdate and user keywords?
How do you define proc in sas? : sas-grid-administration
What are the different options while setting up alerts?
What is android runtime?