1. Categories >> Software >> Databases >> DB Development
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / us

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

More DB Development Interview Questions

You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

0 Answers  

Explain about a primary key?

0 Answers  

How to generate OIDS

0 Answers  

what is difference between primary key and unique key ?

2 Answers  




Given an employee table, how would you find out the second highest salary?

9 Answers  

What are the constraints on severity level in raiseerror?

0 Answers  

How can you log an error to the server event log from a stored procedure?

0 Answers  

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

0 Answers  

Explain about relational operator join?

0 Answers  

What are the types of database model?

0 Answers  

How is data stored in dbms?

0 Answers  

For more DB Development Interview Questions Click Here
Categories