Explain the general syntax for a SELECT statements covering
all the options.
Answer Posted / rosemary masha
select* from table name
where last name='Faina'
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to use online Backups?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are the key features of dbms?
How to read and create .LDC data files which are used by linguatic dictionary.
Explain the rollup operator?
Explain about relational operator join?
Can an extended stored procedure be called from inside a user-defined function?
How to replace not in with not exist?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Where is dbms used?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the types of database model?
I have a few records all are same structures data, I want to store data in multiple targets how
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?
How long can an error message be in raiseerror function?