Help
RSS
API
Feed
Maltego
Contact
Domain > sqlqueryexamples.com
×
Welcome!
Right click nodes and scroll the mouse to navigate the graph.
×
More information on this domain is in
AlienVault OTX
Is this malicious?
Yes
No
DNS Resolutions
Date
IP Address
2025-09-08
3.5.86.63
(
ClassC
)
2025-11-11
3.5.82.31
(
ClassC
)
2026-01-03
52.218.237.18
(
ClassC
)
Port 80
HTTP/1.1 200 OKx-amz-id-2: 3lGPimbVMXTWEmgucBNjrSwrL7KtTl3J3NLi9FMuZykWgqVqLQvopx92do7+FGfuz0/dwJ0J2odXpddJLoLgCUrssgbjk29HediWkh9QGm4x-amz-request-id: XXKWSZCWBQ4CH768Date: Sat, 03 Jan 2026 00:22:24 GMTLast-Modified: Thu, 20 Feb 2020 02:34:14 GMTETag: 84e5e9fab77516cd8f9b0abb7df745d4Content-Type: text/htmlContent-Length: 15831Server: AmazonS3 !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd>html xmlnshttp://www.w3.org/1999/xhtml>!-- InstanceBegin template/Templates/main_template.dwt codeOutsideHTMLIsLockedfalse -->head>meta http-equivContent-Type contenttext/html; charsetutf-8 />!-- InstanceBeginEditable namedoctitle -->title>SQL QUERY EXAMPLES | SQL INTRODUCTION/title>!-- InstanceEndEditable -->link href_css/main.css relstylesheet typetext/css />script srcSpryAssets/SpryMenuBar.js typetext/javascript>/script>link hrefSpryAssets/SpryMenuBarHorizontal.css relstylesheet typetext/css />!-- InstanceBeginEditable namehead -->!-- InstanceEndEditable -->/head>body idcontainer>div idwrapper> div idheader>SQL QUERY EXAMPLES script typetext/javascript> var _gaq _gaq || ; _gaq.push(_setAccount, UA-32433115-1); _gaq.push(_trackPageview); (function() { var ga document.createElement(script); ga.type text/javascript; ga.async true; ga.src (https: document.location.protocol ? https://ssl : http://www) + .google-analytics.com/ga.js; var s document.getElementsByTagName(script)0; s.parentNode.insertBefore(ga, s); })();/script> /div>div idsprymenubar> ul idMenuBar1 classMenuBarHorizontal> li>a classMenuBarHorizontal href#>SQL Basics/a> ul> li>a hrefindex.html titleSQL Introduction>SQL Introduction/a>/li> li>a hrefsql-datatypes.htm titleSQL Datatypes classMenuBarItemVertical>SQL Datatypes/a>/li> li>a hrefsql-logical-operators-and-operator-precedence.htm classMenuBarItemVertical>SQL Logical Operatoras and Operator Precedence/a>/li> /ul> /li> li>a classMenuBarHorizontal href#>SQL Categories/a> ul> li>a classMenuBarItemSubmenu href#>Data Definition Language (DDL)/a> ul> li>a hrefcreate-table-sql.htm>Create Table SQL/a>/li> li>a hrefsql-alter-table.htm>SQL Alter/Modify Table/a>/li> li>a hrefdrop-table-sql.htm>SQL Drop Table/a>/li> /ul> /li> li>a href# classMenuBarItemSubmenu>Data Retrieval Language (DRL)/a> ul> li>a hrefsql-select-query.htm>SQL SELECT Query/a>/li> li>a hrefsql-select-query.htm#sql-alias>SQL Aliases/a>/li> li>a hrefsql-select-query.htm#sql-distinct>SQL DISTINCT/a>/li> li>a hrefsql-select-query.htm#sql-where-clause>SQL WHERE/a>/li> li>a hrefsql-select-query.htm#sql-order-by>SQL ORDER BY/a>/li> li>a hrefsql-select-query.htm#group-by-clause-in-sql>GROUP BY Clause in SQL/a>/li> li>a hrefsql-select-query.htm#having-clause-in-sql>HAVING Clause in SQL/a>/li> li>a hrefsql-case.htm>SQL CASE/a>/li> li>a hrefwebpage-under-construction.htm>SQL DECODE/a>/li> li>a hrefsql-select-query.htm#like-sql>LIKE SQL/a>/li> li>a hrefsql-select-query.htm#sql-in-operator>SQL IN OPERATOR/a>/li> li>a hrefsql-select-query.htm#sql-between>SQL BETWEEN/a>/li> li>a hrefsql-union.htm>SQL UNION/a>/li> /ul> /li> li>a hrefwebpage-under-construction.htm classMenuBarItemSubmenu>Data Manipulation Language (DML)/a> ul> li>a hrefinsert-query-in-sql.htm>INSERT query in SQL/a>/li> li>a hrefupdate-command-in-sql.htm>UPDATE command in SQL/a>/li> li>a hrefmerge-sql.htm>MERGE SQL/a>/li> li>a hrefdelete-query-in-sql.htm>DELETE query in SQL/a>/li> /ul> /li> li>a hrefwebpage-under-construction.htm classMenuBarItemSubmenu>Data Control Language (DCL)/a> ul> li>a hrefsql-grant.htm>SQL Grant/a>/li> li>a hrefsql-revoke.htm>SQL Revoke/a>/li> /ul> /li> /ul> /li> li>a hrefsql-joins.htm classMenuBarHorizontal>SQL Joins/a> ul> li>a hrefsql-joins.htm#sql-inner-join>SQL Inner Join/a>/li> li>a hrefsql-joins.htm#sql-natural-join>SQL Natural Join/a>/li> li>a hrefsql-joins.htm#sql-non-equi-join>SQL Non-equi Join/a>/li> li>a hrefsql-joins.htm#sql-outer-join classMenuBarItemSubmenu>SQL Outer Join/a> ul> li>a hrefsql-joins.htm#sql-left-outer-join>SQL Left Outer Join/a>/li> li>a hrefsql-joins.htm#sql-right-outer-join>SQL Right Outer Join/a>/li> li>a hrefsql-joins.htm#sql-full-outer-join>SQL Full Outer Join/a>/li> /ul> /li> li>a hrefsql-joins.htm#sql-cross-join>SQL Cross Join/a>/li> li>a hrefsql-joins.htm#sql-self-join>SQL Self Join/a>/li>/ul> /li> li>a href# classMenuBarHorizontal>SQL Functions/a> ul>li>a href#>Aggregate Functions/a> ul> li>a hrefsql-avg.htm>SQL Avg/a>/li> li>a hrefcount-sql.htm>Count SQL/a>/li> li>a hrefsql-max.htm>SQL Max/a>/li> li>a hrefsql-min.htm>SQL Min/a>/li> li>a hrefsql-rank.htm>SQL Rank/a>/li> li>a hrefsum-sql.htm>Sum SQL/a>/li> /ul>/li>li>a href# classMenuBarItemSubmenu MenuBarItemSubmenu>Character Funtions/a> ul> li>a hrefsql-ascii.htm>SQL ASCII/a>/li> li>a hrefsql-chr.htm>SQL CHR/a>/li> li>a hrefsql-concat.htm>SQL CONCAT/a>/li> li>a hrefsql-initcap.htm>SQL INITCAP/a>/li> li>a hrefsql-instr.htm>SQL INSTR/a>/li> li>a hrefsql-length.htm>SQL LENGTH/a>/li> li>a hrefsql-lower.htm>SQL LOWER/a>/li> li>a hrefsql-lpad.htm>SQL LPAD/a>/li> li>a hrefltrim-sql.htm>SQL LTRIM/a>/li> li>a hrefsql-replace.htm>SQL REPLACE/a>/li> li>a hrefsql-rpad.htm>SQL RPAD/a>/li> li>a href#>SQL RTRIM/a>/li> li>a href#>SQL SUBSTR/a>/li>li>a href#>SQL TRANSLATE/a>/li>li>a href#>SQL TRIM/a>/li> li>a href#>SQL UPPER/a>/li> /ul>/li>li>a href# classMenuBarItemSubmenu MenuBarItemSubmenu>Conversion Functions/a> ul>li>a hrefsql-to_char.htm>SQL TO_CHAR/a>/li>li>a hrefsql-to_date.htm>SQL TO_DATE/a>/li>li>a hrefsql-to_number.htm>SQL TO_NUMBER/a>/li> li>a hrefsql-to_timestamp.htm>SQL TO_TIMESTAMP/a>/li> /ul>/li>li>a href# classMenuBarItemSubmenu MenuBarItemSubmenu>Date/Time Functions/a> ul> li>a hrefsql-add_months.htm>SQL ADD MONTHS/a>/li> li>a hrefsql-last_day.htm>SQL LAST DAY of month/a>/li> li>a hrefsql-months_between.htm>SQL MONTHS BETWEEN/a>/li> li>a hrefsql-round.htm>SQL ROUND/a>/li> li>a hrefsql-sysdate.htm>SQL SYSDATE/a>/li> li>a hrefsql-trunc.htm>SQL TRUNC/a>/li> li>a hrefsql-to_char.htm>SQL TO_CHAR/a>/li> /ul>/li>li>a href# classMenuBarItemSubmenu MenuBarItemSubmenu>Null Functions/a> ul> li>a hrefsql-nvl.htm>SQL NVL/a>/li> li>a hrefsql-nvl2.htm>SQL NVL2/a>/li> li>a hrefnullif-sql.htm>SQL NULLIF/a>/li> li>a hrefsql-coalesce.htm>SQL COALESCE/a>/li> /ul>/li>li>a href# classMenuBarItemSubmenu>Numeric Functions/a> ul> li>a hrefsql-abs.htm>SQL ABS/a>/li> li>a hrefsql-ceil.htm>SQL CEIL/a>/li> li>a hrefsql-floor.htm>SQL FLOOR/a>/li> li>a hrefsql-mod.htm>SQL MOD/a>/li> li>a hrefsql-round-number.htm>SQL ROUND/a>/li> li>a hrefsql-sign.htm>SQL SIGN/a>/li> li>a hrefsql-to_date.htm>SQL TO_DATE/a>/li> li>a hrefsql-trunc-number.htm>SQL TRUNC/a>/li> /ul>/li>/ul> /li> li>a hrefwebpage-under-construction.htm classMenuBarHorizontal MenuBarItemSubmenu>SQL Constraints/a> ul> li>a hrefsql-unique.htm>SQL Unique/a>/li> li>a hrefprimary-key-in-sql.htm>PRIMARY KEY in SQL/a>/li> li>a hrefsql-foreign-key.htm>SQL FOREIGN KEY/a>/li> li>a hrefcheck-sql.htm>CHECK SQL/a>/li> li>a hrefsql-not-null.htm>SQL NOT NULL/a>/li> /ul> /li> li>a classMenuBarHorizontal href#>SQL Keywords/a> ul> li>a hrefsql-select-query.htm#sql-between>SQL BETWEEN/a>/li> li>a hrefsql-select-query.htm#sql-distinct>SQL DISTINCT/a>/li> li>a hrefsql-select-query.htm#like-sql>LIKE SQL/a>/li>li>a hrefsql-select-query.htm#sql-where>SQL WHERE/a>/li> /ul> /li>/ul> /div>div idsearchbar> style typetext/css>@import url(http://www.google.com/cse/api/branding.css);/style> div classcse-branding-bottom stylebackground-color:#FFFFFF;color:#000000> div classcse-branding-form> form actionhttp://www.google.ca idcse-search-box target_blank> div> input typehidden namecx valuepartner-pub-6445594718002694:1279402410 /> input typehidden nameie valueUTF-8 /> input typetext nameq size30 /> input typesubmit namesa valueSearch /> /div> /form> script typetext/javascript srchttp://www.google.com/jsapi>/script> script typetext/javascript>google.load(elements, 1, {packages: transliteration});/script> script typetext/javascript srchttp://www.google.com/cse/t13n?formcse-search-box&t13n_langsen>/script> /div> /div>/div> div idmenu>/div> div idsidebar1> h3 idsprymenubar>Other related articles: /h3> p> script typetext/javascript>!--google_ad_client ca-pub-6445594718002694;/* Wide Skyscraper */google_ad_slot 4604422413;google_ad_width 160;google_ad_height 600;//-->/script>script typetext/javascriptsrchttp://pagead2.googlesyndication.com/pagead/show_ads.js>/script> /p> /div>div idsidebar2> h3>Recently viewed articles: /h3> P> script typetext/javascript>!--google_ad_client ca-pub-6445594718002694;/* Skyscraper */google_ad_slot 8549513618;google_ad_width 120;google_ad_height 600;//-->/script>script typetext/javascriptsrchttp://pagead2.googlesyndication.com/pagead/show_ads.js>/script> /P>/div>div idmaincontent>div idcontent>!-- InstanceBeginEditable namemainContent --> h2>SQL Introduction/h2> div idad1> script typetext/javascript>!--google_ad_client ca-pub-6445594718002694;/* Small Square1 */google_ad_slot 5037644017;google_ad_width 200;google_ad_height 200;//-->/script>script typetext/javascriptsrchttp://pagead2.googlesyndication.com/pagead/show_ads.js>/script>/div> p>strong>Structured Query Language/strong>, most often called (strong>S-Q-L/strong>), is Database Query Language used to manipulate and extract data from Database. It was originally called Structured English Query Language (in short SEQUEL) by IBM. But after sometime IBM found that SEQUEL was a trademark for UK based em>Hawker Siddeley Aircraft Company/em>, it dropped word “English” and acronym was change to SQL. SQL Syntax is a simple English statement, thus makes SQL based queries one of the most easy to understand and learn.br />SQL is based on declarative approach which makes it different from other computer language (usually procedural approach). In SQL, we write what we need and system itself finds the best procedure to get that information. On the other hand, in procedural approach we have to define how to get that information.br />SQL is used:/p> ul typedisc> li>to create database schema and its objects./li> li>to store data into these objects./li> li>to manipulate the stored data./li> li>to retrieve data from database./li> li>To control security of database./li> /ul> p>The way SQL interacts with database is shown in figure below:br /> img width445 height295 src/_images/intro.jpg althttp://sqlqueryexamples.com/sql-query-examples/wp-content/uploads/2012/07/intro.jpg /> br /> strong>Database Management System/strong> (most often called strong>DBMS/strong>) is a system which controls database. SQL is used to make request to DBMS, then DBMS analyze the request and returns data specific to that request. This whole process is called em>query./em>br /> script typetext/javascript>!--google_ad_client ca-pub-6445594718002694;/* Horizontal Large */google_ad_slot 6514377214;google_ad_width 728;google_ad_height 15;//-->/script>script typetext/javascriptsrchttp://pagead2.googlesyndication.com/pagead/show_ads.js>/script> Data is basically stored in the form of table (rows and columns). The following example shows a very simple form of table.br /> EMP/p> table border1 cellspacing0 cellpadding0> tr> td width73 valigntop>br /> EMPNO /td> td width78 valigntop>p>ENAME/p>/td> td width60 valigntop>p>SAL/p>/td> td width132 valigntop>p>JOB/p>/td> td width78 valigntop>p>DEPTNO/p>/td> /tr> tr> td width73 valigntop>p>4621/p>/td> td width78 valigntop>p>RAJ/p>/td> td width60 valigntop>p>1000/p>/td> td width132 valigntop>p>SALESPERSON/p>/td> td width78 valigntop>p>10/p>/td> /tr> tr> td width73 valigntop>p>4852/p>/td> td width78 valigntop>p>SMITH/p>/td> td width60 valigntop>p>5000/p>/td> td width132 valigntop>p>MANAGER/p>/td> td width78 valigntop>p>10/p>/td> /tr> tr> td width73 valigntop>p>4932/p>/td> td width78 valigntop>p>SCOTT/p>/td> td width60 valigntop>p>2000/p>/td> td width132 valigntop>p>CLERK/p>/td> td width78 valigntop>p>20/p>/td> /tr> /table> p>: where EMP is a table name. EMPNO, ENAME, SAL and so on are column names, also called attributes. Each row in a table represents one record.br /> A simple SQL query to this database could be:br /> em> SELECT ename FROM emp;/em>/p> ul typedisc> li>SELECT is SQL keyword which tells DBMS to select some data./li> li>Ename is a column name, as shown is table above./li> li>FROM is again SQL keyword which tells DBMS the table name from where to fetch data./li> li>Emp is a em>table name/em> for above table/li> /ul>!-- InstanceEndEditable -->/div>/div>div idfooter> p>© 2013 SQL Query Examples. All rights reserved. | Get more information about SQL Query Examples by visiting our About section./p> p> /p> p> /p>/div>/div>script typetext/javascript>var MenuBar1 new Spry.Widget.MenuBar(MenuBar1, {imgDown:SpryAssets/SpryMenuBarDownHover.gif, imgRight:SpryAssets/SpryMenuBarRightHover.gif});/script>/body>!-- InstanceEnd -->/html>
View on OTX
|
View on ThreatMiner
Please enable JavaScript to view the
comments powered by Disqus.
Data with thanks to
AlienVault OTX
,
VirusTotal
,
Malwr
and
others
. [
Sitemap
]