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 are the 18 schemas?

0 Answers  

---

What is an application role and explain a scenario when you would use one?

0 Answers  

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers  

---

In which database can extended stored procedures be added?

0 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

2 Answers  

---

Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

0 Answers  

---

Write short notes on XSU and JAVA

1 Answers  

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

0 Answers  

---

What are the three types of database design?

0 Answers  

---

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

3 Answers  

---