Explain the general syntax for a SELECT statements covering all the options.

Explain the general syntax for a SELECT statements covering
all the options.

Question Posted / guest

3 Answers
6611 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Explain the general syntax for a SELECT statements covering all the options...

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]

Is This Answer Correct ?

12 Yes

1 No

Explain the general syntax for a SELECT statements covering all the options...

Answer / rosemary masha

select* from table name
where last name='Faina'

Is This Answer Correct ?

1 Yes

1 No

Explain the general syntax for a SELECT statements covering all the options...

Answer / dinesh sharma

select * from tablename(select all fields of the tables)
select f1,f2 from tablename (select selected fields(like
f1,f2)
select f1,f2,2 [f3] from tablename(select selected fields
plus one fields having default value is 2)

Is This Answer Correct ?

0 Yes

6 No

Post New Answer