Answer Posted / amit

Select salary
from employees
order by salary desc
limit n-1,1;

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

584

---

What is sub query and its properties?

545

---

Can one drop a column from a table?

552

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2468

---

How to enable tcp/ip protocol on a sql server?

587

---

---

Does hive support indexing?

519

---

What is a group function explain with an example?

523

---

What is primary key and example?

502

---

What is the maximum size per database for sql server express?

557

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

78

---

What is partition in sql server?

529

---

What is autocommit mode in sql server?

544

---

How do you use a subquery to find records that exist in one table and do not exist in another?

548

---

Some queries related to SQL

588

---

What is the difference RDBMS and Graph Database?

629

---