Answer Posted / sachin

select max(sal) from employees
where salary < (select max(sal) from employees);

what are the authentication modes in sql server? How can it be changed? : Sql dba

703

---

is mysql query is case sensitive? : Sql dba

565

---

What are system versioned tables?

553

---

What is set serveroutput on in pl sql?

567

---

how to analyze tables with 'mysqlcheck'? : Sql dba

547

---

---

Why is a primary key important?

547

---

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

621

---

What is cte?

574

---

What is prepared statement in sql?

547

---

what are aggregate and scalar functions? : Sql dba

552

---

What is sql and also describe types of sql statements?

567

---

what is subquery? : Sql dba

573

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

691

---

What is difference between stored procedures and application procedures?

572

---

Why do we use triggers?

522

---