Answer Posted / guest

select max(sal) from tab_name;
or
select * from tab_name where sal=(select max(sal) from
tab_name) and rownum<=1;

How can I tell if sql is running?

594

---

State some properties of relational databases?

586

---

What is multiple columns?

576

---

What is an emotional trigger?

520

---

What is a sql statement?

537

---

---

What is scope and visibility in PL/SQL?

604

---

How do I know if I have sql express or standard?

608

---

What is the difference between distinct and unique in sql?

476

---

how to fetch common records from two tables? : Sql dba

633

---

Can we use the cursor's to create the collection in PL/SQL?

524

---

What is the difference between database trigger and stored procedure?

559

---

Which data dictionary views have the information on the triggers that are available in the database?

758

---

Which one is better sql or oracle?

506

---

What do you mean by stored procedures?

555

---

What is consistency?

717

---