Top 20 sql interview questions and answers

Posted Posted in Android, Automation/QTP/Selenium Blogs, Java, JavaScript, Others, questions, Selenium Cucumber, SQL, Trending, Wordpress
Top 20 sql interview questions and answers What is DDL, DML, DCL, TCL in SQL ? DDL refers to Data Definition language. DDL is used to create/modify the structure of Database. e.g. CREATE, ALTER, DROP statement.. DML refers to Data Manipulation language. DML is used to retrieve, modify, delete, insert and update data in database. e.g. […]

Summary of SQL

Posted Posted in Android, questions, SQL, Wordpress
What are the SQL MAX() and MIN() Functions? The MAX() function returns the largest value in the selected column. The MIN() function returns the smallest value in the selected column. SELECT MAX(Weight) AS LargestWeight FROM CricketBats ; SELECT MIN(Weight) AS SmallestWeight FROM CricketBats ; What are the SQL AVG(), COUNT() and SUM() Functions The SQL […]

What is AND, OR and NOT Operators in SQL

Posted Posted in Android, Apache, Automation Framework, Automation/QTP/Selenium Blogs, Google adsense, Java, JavaScript, questions, SQL, Technical blog, Trending
AND, OR, and NOT operators are combined with the WHERE clause to get the desired filtered results.   e.g SELECT * FROM Users WHERE State =’illinois’ AND City=’Chicago’;   e.g SELECT * FROM Users WHERE City=’Chicago’ OR City=’New York’;   e.g SELECT * FROM Users WHERE NOT State =’Chicago’;

What is difference between select and select distinct

Posted Posted in Android, Apache, Automation Framework, Automation/QTP/Selenium Blogs, Google adsense, Java, JavaScript, questions, SQL, Technical blog, Trending
SELECT DISTINCT statement is used for returning only distinct (different) values from a column.   SELECT statement is used for returning all the values in the table column.   E.g SELECT States FROM Customers; E.g SELECT DISTINCT States FROM Customers;   Summary of SQL – Please click here