Answer Posted / sharmila shree

SELECT TOP 1 salary FROM
( SELECT DISTINCT TOP 1 salary FROM table_name
ORDER BY salary DESC )
a ORDER BY salary

here 'a' is sub query of salary

Which table keeps the locking information?

931

---

How to modify the underlying query of an existing view?

991

---

Do you know the different ddl commands in sql?

1059

---

What is simple indexing method?

1039

---

How do I start sql server 2017?

945

---

How do I debug a stored procedure in sql server?

1113

---

Define normalisation?

1118

---

What are click through reports?

145

---

How to drop an existing table?

1012

---

How to execute multiple stored procedures at one time in sql server?

1016

---

how many no of arguments can be passed in procedures and functions

5569

---

What is single-user mode?

947

---

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1065

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2367

---

What is the Control Flow in SSIS

1097

---