Answer Posted / divya

select max(sal) from tablename where sal<(select
max(sal)from tablename)

What is primary key index?

962

---

Explain the concept of view and Types of views in SQL server?

969

---

What is the difference between executequery () and executeupdate ()?

1007

---

What are the steps you should follow to start sql server in single-user mode?

877

---

Are all views updatable ?

1134

---

How to fine-tune reports?

264

---

How to create a new login name in ms sql server?

1040

---

How do I know if localdb is running?

928

---

How do you rename a table in sql server?

1001

---

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

2213

---

What are the instances when triggers are appropriate?

965

---

What is data source view or dsv? : sql server analysis services, ssas

981

---

Is it safe to delete log files?

899

---

What is difference between equi join and inner join?

916

---

What are the advantages of user-defined functions over stored procedures in sql server?

1014

---