Answer Posted / sikindar

select * from emp where sal=(
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal));

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

2292

---

How to configure odbc dsn with different port numbers?

1154

---

How to drop an existing stored procedure in ms sql server?

1088

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

947

---

Explain the use of containers in ssis and also their types?

1019

---

How to copy data from one table to another table?

1051

---

What are the 2 types of classifications of constraints in the sql server?

1182

---

What is a not null constraint?

1088

---

What are the dmvs? : sql server database administration

1122

---

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

998

---

How to use go command in "sqlcmd"?

1267

---

How many types of attribute relationships are there? : sql server analysis services, ssas

1133

---

What is 1nf 2nf?

1060

---

What is the Disadvantage of indexed sequential file.

1130

---

How to disconnect from a sql server using mssql_close()?

1169

---