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;

what is the command used to fetch first 5 characters of the string? : Sql dba

1680

---

How can I tell if sql is running?

1126

---

Can you have a foreign key without a primary key?

997

---

Explian rowid, rownum?

1075

---

What is the difference between joins?

1093

---

How do I upgrade sql?

1048

---

Which is faster subquery or join?

1268

---

Explain the savepoint statement.

1135

---

Can a table contain multiple foreign key’s?

1049

---

What are the different type of joins in sql?

997

---

Are views faster than queries?

1038

---

Explain raise_application_error.

1143

---

what are the 'mysql' command line arguments? : Sql dba

1186

---

How can triggers be used for the table auditing?

1117

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1277

---