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]

Answer / rosemary masha

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

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)

Who are end users in dbms?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

Explain about the relational database?

0 Answers  

---

What are the types of database model?

0 Answers  

---

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?

0 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

Explain the family trees and connection by clause.

1 Answers  

---

How to use timestamp datatypes

0 Answers  

---

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

3 Answers  

---

Write short notes on XSU and JAVA

1 Answers  

---

hi in which phase of mload can i use .FILLER

1 Answers   IBM,

---

Explain what a database is?

0 Answers  

---