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 |
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?
Explain about the database management systems.
I have a few records all are same structures data, I want to store data in multiple targets how
0 Answers CTR, Infosys, Polaris,
What are triggers? How many triggers you can have on a table?
Explain the family trees and connection by clause.
what is the use of foreginkey
How to combine two function together?
How to customize error conditions.
How would you design a database for an online site, which would average a million hits a day?
What are the main phases of database development?
Can you instantiate a COM object by using T-SQL?
Explain about normal forms?