SQL Statements and there Syntax

By -

SQL Statements and there Syntax

SQL Statement
Syntax
AND / OR
SELECT column_name(s) FROM table_name WHERE condition
AND|OR condition;
ALTER TABLE
ALTER TABLE table_name ADD column_name datatype ;
or
ALTER TABLE table_name DROP COLUMN column_name;
AS (alias)
SELECT column_name AS column_alias FROM table_name;
or
SELECT column_name FROM table_name  AS table_alias;
BETWEEN
SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2;
CREATE DATABASE
CREATE DATABASE database_name;
CREATE TABLE
CREATE TABLE table_name (column_name1 data_type,
column_name2 data_type,column_name2 data_type,...);
CREATE INDEX
CREATE INDEX index_name ON table_name (column_name);
or
CREATE UNIQUE INDEX index_name ON table_name (column_name);
CREATE VIEW
CREATE VIEW view_name AS SELECT column_name(s)
FROM table_name WHERE condition;
DELETE
DELETE FROM table_name WHERE some_column=some_value;
or
DELETE FROM table_name ;
DELETE * FROM table_name ;
DROP DATABASE
DROP DATABASE database_name;
DROP INDEX
DROP INDEX table_name.index_name (SQL Server)
DROP INDEX index_name ON table_name (MS Access)
DROP INDEX index_name (DB2/Oracle);
ALTER TABLE table_name DROP INDEX index_name (MySQL)
DROP TABLE
DROP TABLE table_name;
GROUP BY
SELECT column_name, aggregate_function(column_name);
FROM table_name WHERE column_name operator value
GROUP BY column_name;
HAVING
SELECT column_name, aggregate_function(column_name)
FROM table_name WHERE column_name operator value
GROUP BY column_name HAVING aggregate_function(column_name) operator value;
IN
SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,..);
INSERT INTO
INSERT INTO table_name VALUES (value1, value2, value3,....);
or
INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,....);
INNER JOIN
SELECT column_name(s) FROM table_name1
INNER JOIN table_name2 ON table_name1.column_name=table_name2.column_name;
LEFT JOIN
SELECT column_name(s) FROM table_name1 LEFT JOIN table_name2  ON table_name1.column_name=table_name2.column_name;
RIGHT JOIN
SELECT column_name(s) FROM table_name1 RIGHT JOIN table_name2 ON table_name1.column_name=table_name2.column_name;
FULL JOIN
SELECT column_name(s) FROM table_name1
FULL JOIN table_name2 ON table_name1.column_name=table_name2.column_name;
LIKE
SELECT column_name(s) FROM table_name WHERE column_name LIKE pattern;
ORDER BY
SELECT column_name(s) FROM table_name
ORDER BY column_name [ASC|DESC];
SELECT
SELECT column_name(s) FROM table_name;
SELECT *
SELECT *FROM table_name;
SELECT DISTINCT
SELECT DISTINCT column_name(s)FROM table_name;
SELECT INTO
SELECT * INTO new_table_name [IN externaldatabase]
FROM old_table_name;
or
SELECT column_name(s) INTO new_table_name [IN externaldatabase] FROM old_table_name;
SELECT TOP
SELECT TOP number|percent column_name(s)
FROM table_name;
TRUNCATE TABLE
TRUNCATE TABLE table_name
UNION
SELECT column_name(s) FROM table_name1
UNION
SELECT column_name(s) FROM table_name2;
UNION ALL
SELECT column_name(s) FROM table_name1
UNION ALL
SELECT column_name(s) FROM table_name2;
UPDATE
UPDATE table_name SET column1=value, column2=value,...
WHERE some_column=some_value ;
WHERE
SELECT column_name(s) FROM table_name
WHERE column_name operator value;


Comments

Post a Comment

Popular posts from this blog

Handling Dynamic Web Tables Using Selenium WebDriver

By -
Image
There are two types of HTML tables published on the web- Static tables : Data is static i.e. Number of rows and columns are fixed. Dynamic tables : Data is dynamic i.e. Number of rows and columns are NOT fixed.Handling static table is easy, but dynamic table is a little bit difficult as rows and columns are not constant. Using X-Path to Locate Web Table Elements Before we locate web element, first let's understands- What is a web element? Web elements are nothing but HTML elements like textbox, dropdowns radio buttons, submit buttons, etc. These HTML elements are written with  start  tag and ends with an  end  tag. For Example, <p>  My First HTML Document </p>. Steps for getting X-path of web element that we want to locate. Step 1)  In Chrome, Go to  http://money.rediff.com/gainers/bsc/daily/groupa Step 2)  Right click on web element whose x-path is to be fetched. In our case, right click on "Company" Se...
Read more

Verify Specific Position of an Element

By -
Verify Specific Position of an Element Selenium IDE indicates the position of an element by measuring (in pixels) how far it is from the left or top edge of the browser window. ·          verifyElementPositionLeft   - verifies if the specified number of pixels match the distance of the element from the left edge of the page. This will return FALSE if the value specified does not match the distance from the left edge. ·          verifyElementPositionTop   - verifies if the specified number of pixels match the distance of the element from the top edge of the page. This will return FALSE if the value specified does not match the distance from the top edge.
Read more

Read it out for TESTNG before going for an iterview

By -
How to run a group of test cases using TestNG? TestNG allows you to perform sophisticated groupings of test methods. Not only can you declare that methods belong to groups, but you can also specify groups that contain other groups. Then TestNG can be invoked and asked to include a certain set of groups (or regular expressions) while excluding another set.  This gives you maximum flexibility in how you partition your tests and doesn’t require you to recompile anything if you want to run two different sets of tests back to back. Groups are specified in your testng.xml file and can be found either under the <test> or <suite> tag. Groups specified in the <suite> tag apply to all the <test> tags underneath. @Test (groups = { "smokeTest", "functionalTest" }) public void loginTest(){ System.out.println("Logged in successfully"); }   How to create Group of Groups in TestNG? Groups can also inc...
Read more