general syntax for a SELECT statements

Ads
 

general syntax for a SELECT statements

Write down the general syntax for a SELECT statements covering all the options

View Answers

November 20, 2010 at 12:05 PM

Hi,

The general syntax of a select statement covering all the options is as follows,

this syntax shows how we can use different optin with the select statements.

SELECT select_list
[INTO new_table_]
FROM table_source
[WHERE search_condition]
[GROUP BY group_by_expression]
[HAVING search_condition]
[ORDER BY order_expression [ASC | DESC] ;

Thanks,

Ads









Related Tutorials/Questions & Answers:
Objective C if else statements syntax
Objective C if else statements syntax  What is the syntax of if else statements in Objective C?   Using of if else statement in Objective C There is no changes in the syntax format of if else statement. You can write
general
Advertisements
general
general
Programming (general)
Programming (general)  I haven't yet started college/university but I'm interested in studying programming. I wondering if programming is difficult or confusing with all the codes you have to learn? Also how many languages would
syntax for create a table
syntax for create a table  syntax for create a table
javascript comment syntax html
javascript comment syntax html  javascript comment syntax html
Control Flow Statements in java 7
Control Flow Statements in java 7 In this section we will discuss Control Flow Statements in java 7. This is one type of Language Fundamentals. Control Flow Statements : - In general program execution flow is from top to bottom
Text Editor with Syntax Highlighting
Text Editor with Syntax Highlighting   How to write a java program for text editor with syntax highlighting
ModuleNotFoundError: No module named 'syntax'
ModuleNotFoundError: No module named 'syntax'  Hi, My Python... 'syntax' How to remove the ModuleNotFoundError: No module named 'syntax'... to install padas library. You can install syntax python with following command
ModuleNotFoundError: No module named 'general'
ModuleNotFoundError: No module named 'general'  Hi, My Python... 'general' How to remove the ModuleNotFoundError: No module named 'general... to install padas library. You can install general python with following command
DECESION MAKING STATEMENTS
DECESION MAKING STATEMENTS  The Decision Making statements may be implemented in different forms depending on the complexity of the condition to be tested. Describe various forms of decision making statements in java
Executing Set of SQL statements in Java
= cstmt.executeQuery(); The procedure has drop temp table statements, select multiple values from tables with different conditions, storing in a temp table, select...Executing Set of SQL statements in Java  Hi, I am trying to execute
sql syntax error help
sql syntax error help  this query show syntax error .. i am unable to figure it out insert into order (orderdate, dpname, paymethod, tamount, pquantity,shipid) values(now(),'$dpname' ,cod, '$tamount', '$itmqty', '$ship_id
Looping Statements in java 7
Looping Statements in java 7 In this section, we will discuss about Looping Statements in java 7. This is one type of control flow statement. Looping Statements : This kind of statements are used where you need to execute block
Branching Statements in java 7
. Syntax : loop (...){ condition{ continue; } ......//statements } Return...Branching Statements in java 7 In this section, we will discuss about Branching Statements in java 7. This is one type of control flow statement. Branching
Avoiding â??!= nullâ?? statements in Java?
Avoiding ‚??!= null‚?? statements in Java?  Avoiding ‚??!= null‚?? statements in Java
PHP Code Syntax
PHP Code Syntax PHP syntax is the set of rules which need to be followed to to write properly structured PHP code. Given below Some rules of PHP syntax..., it will not execute properly. There are two basic statements to output text
Java Control Statements
Java Control Statements       Introduction to Control Statements In this section, we are going to discuss the control statements. Different types of control statements
Decision-making Statements in java 7
Decision-making Statements in java 7 In this section, we will discuss about Decision-making Statements in java 7. This is one type of control flow statement. Decision-making Statements : This kind of control statements is used where
ModuleNotFoundError: No module named 'flake8-if-statements'
ModuleNotFoundError: No module named 'flake8-if-statements'  Hi...: No module named 'flake8-if-statements' How to remove the ModuleNotFoundError: No module named 'flake8-if-statements' error? Thanks   Hi
ModuleNotFoundError: No module named 'flake8-if-statements'
ModuleNotFoundError: No module named 'flake8-if-statements'  Hi...: No module named 'flake8-if-statements' How to remove the ModuleNotFoundError: No module named 'flake8-if-statements' error? Thanks   Hi
ModuleNotFoundError: No module named 'hilite-syntax'
ModuleNotFoundError: No module named 'hilite-syntax'  Hi, My... 'hilite-syntax' How to remove the ModuleNotFoundError: No module named 'hilite-syntax' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'json-syntax'
ModuleNotFoundError: No module named 'json-syntax'  Hi, My Python... 'json-syntax' How to remove the ModuleNotFoundError: No module named 'json-syntax' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'moshmosh-syntax'
ModuleNotFoundError: No module named 'moshmosh-syntax'  Hi, My... named 'moshmosh-syntax' How to remove the ModuleNotFoundError: No module named 'moshmosh-syntax' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'ninja_syntax'
ModuleNotFoundError: No module named 'ninja_syntax'  Hi, My Python... 'ninja_syntax' How to remove the ModuleNotFoundError: No module named 'ninja_syntax' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'syntax-diagram'
ModuleNotFoundError: No module named 'syntax-diagram'  Hi, My... named 'syntax-diagram' How to remove the ModuleNotFoundError: No module named 'syntax-diagram' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'syntax-diagram'
ModuleNotFoundError: No module named 'syntax-diagram'  Hi, My... named 'syntax-diagram' How to remove the ModuleNotFoundError: No module named 'syntax-diagram' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'syntax_sugar'
ModuleNotFoundError: No module named 'syntax_sugar'  Hi, My Python... 'syntax_sugar' How to remove the ModuleNotFoundError: No module named 'syntax_sugar' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'general-config'
ModuleNotFoundError: No module named 'general-config'  Hi, My... named 'general-config' How to remove the ModuleNotFoundError: No module named 'general-config' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'general-conversors'
ModuleNotFoundError: No module named 'general-conversors'  Hi, My... named 'general-conversors' How to remove the ModuleNotFoundError: No module named 'general-conversors' error? Thanks   Hi, In your

Ads