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)

what is Normalization?

6 Answers   TCS,

---

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

0 Answers  

---

Who are end users in dbms?

0 Answers  

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,

---

What are the main phases of database development?

0 Answers  

---

how will I find the duplicate rows count from employees tablein oracle.

2 Answers  

---

What are cursors? Explain different types of cursors?

6 Answers  

---

What are the types of database model?

0 Answers  

---

What is a join and explain different types of joins?

2 Answers  

---

Which four data types cannot be used as a return type from a user-defined function?

0 Answers  

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

---

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?

0 Answers  

---