Explain the general syntax for a SELECT statements covering
all the options.
Answers were Sorted based on User's Feedback
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 |
Answer / rosemary masha
select* from table name
where last name='Faina'
Is This Answer Correct ? | 1 Yes | 1 No |
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 |
Write short notes on XSU and JAVA
What are the main phases of database development?
What is a database development?
What are the types of database model?
What are the disadvantages of cursors? How can you avoid cursors?
Define candidate key, alternate key, composite key?
30 Answers IAS, IBM,
What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?
What are the key features of dbms?
Explain about network model?
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?
What are the three types of database design?
What are the constraints on severity level in raiseerror?