Source Code 4 you

Structured Query Language

Question Total Page View * How would you find out the total number of rows in a table?             91             * How do you eliminate duplicate values in SELECT ?             64             * How you insert records into a table             96             * How do you delete record from a table ?             66             * How do you select a row using indexes?             76             * How do you find the maximum value in a column?             66             * How do you retrieve the first 5 characters of FIRSTNAME column of table EMP ?             81             * My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?             97             * How do you concatenate the FIRSTNAME and LASTNAME from EMP table to give a complete name?             62             * In the WHERE clause what is BETWEEN and IN?             69             * Is BETWEEN inclusive of the range values specified?             64             * What is 'LIKE' used for in WHERE clause? What are the wildcard characters?             82             * Is BETWEEN inclusive of the range values specified?             76             * What is 'LIKE' used for in WHERE clause? What are the wildcard characters?             70             * When do you use a LIKE statement?             122             * What do you accomplish by GROUP BY ... HAVING clause?             90             * Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?             75             * What are the large objects supported by oracle and db2?             126             * What's the difference between a primary key and a unique key?             84             * What is a join and explain different types of joins?             66             * What is a self join?             88