Answer Posted / k.elumalai

select max(salary)from emp where salary <(select sum(salary)
from emp)

Working with TLogs

1833

---

What is a constant or literal in ms sql server?

1048

---

Explain hostprotectionattribute in sql server 2005?

1035

---

What is the fillfactor concept in indexes?

986

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2241

---

Explain why variables called the most powerful component of ssis?

1102

---

How to concatenate two strings in SQL Server.

1150

---

How to create a ddl trigger using "create trigger" statements?

1135

---

How do I start sql server 2016?

910

---

How to backup encryption key ?

182

---

What is the server name for sql management studio?

1025

---

What command is used to delete a table from the database in the sql server and how?

1114

---

How network traffic be reduced by using the stored procedure?

1118

---

How to execute a sql statement using odbc_exec()?

1144

---

How to specify the collation for a character data type in ms sql server?

1030

---