What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 64064In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 23750How 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 11150A 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 12965Post New Infosys SQL Server Interview Questions
How will change the instance give type for the instances, which are the running in your applications tier and then using auto scaling. Where will you change it from areas?
What do you mean by durability in dbms?
what is the difference between == and eq in UNIX shell scripting?
Can a void pointer point to a function?
What is difference between innerhtml and value?
Explain the special skills and qualities you have which make you perfect for this job?
What are cognos connection initial page components?
What are the benefits of ejb?
You are the project manager for a web development project. You hold regular project status meetings and publish status reports on a timely basis. You know that communication is one of your most important functions. As such, all of the following are true except: A. Senders are responsible for sending clear, concise, complete messages. B. Receivers are responsible for understanding the message. C. Communication can be vertical or horizontal or both. D. Effective communication techniques include making eye contact, nodding, and asking clarifying questions.
Where do we use cross and standard cable?
What is difference between print_r and echo in php?
Is ios written in swift?
Which transformation we use to convert 'NA' to 'Not Available'
What are recursive functions?
Is it possible to reduce the size of a already created partition?