Answer Posted / manvar prajesh

select top 1 name,salary from emp where salary<(select
max(salary) from emp)order by salary desc

What is the difference between clustered and non-clustered index in sql?

1017

---

What is set transaction?

1040

---

What is number function in sql?

980

---

What is rowid in sql?

991

---

What is column?

996

---

What are the most important ddl statements in sql?

1117

---

Does truncate release storage space?

1083

---

How do you determine the current isolation level? : Transact sql

1161

---

what is top in tsql? : Transact sql

1123

---

Can we use pl sql in sql server?

1086

---

What are tables in sql?

1070

---

how to convert numeric values to character strings? : Sql dba

1110

---

Explain raise_application_error.

1101

---

Can a composite key be null?

981

---

What is the difference between python and sql?

1008

---