Source Code 4 you

Structured Query Language

Question Total Page View * How would you find out the total number of rows in a table?             175             * How do you eliminate duplicate values in SELECT ?             108             * How you insert records into a table             166             * How do you delete record from a table ?             123             * How do you select a row using indexes?             148             * How do you find the maximum value in a column?             116             * How do you retrieve the first 5 characters of FIRSTNAME column of table EMP ?             127             * My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?             151             * How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?             126             * In the WHERE clause what is BETWEEN and IN?             125             * Is BETWEEN inclusive of the range values specified?             99             * What is 'LIKE' used for in WHERE clause? What are the wildcard characters?             150             * Is BETWEEN inclusive of the range values specified?             152             * What is 'LIKE' used for in WHERE clause? What are the wildcard characters?             130             * When do you use a LIKE statement?             174             * What do you accomplish by GROUP BY ... HAVING clause?             136             * Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?             119             * What are the large objects supported by oracle and db2?             184             * What's the difference between a primary key and a unique key?             150             * What is a join and explain different types of joins?             112             * What is a self join?             158