Answer / guest

select * from employee
where sal =
(select * from max(sal) from emp)

Answer / brain group

what type of sql statement you asked ?

What is the difference between lock, block and deadlock? : sql server database administration

0 Answers  

---

How do I manually uninstall an instance of sql server 2016?

0 Answers  

---

What is a stored procedure?

3 Answers  

---

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

0 Answers   HCL, Wipro,

---

What is key attribute?

0 Answers  

---

What is the use of keyword with encryption.

0 Answers  

---

How do I make a resultset scrollable?

0 Answers  

---

What is cursor ? And what is difference between Trigger ?

3 Answers   HCL, Polaris,

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

How do you connect 100 files as a flat file sources in one package of SSIS?

2 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

---