Answer Posted / praveend

This query ill run on MySQL

CREATE TABLE IF NOT EXISTS `stu` (
`id` int(5) DEFAULT NULL,
`sname` varchar(20) DEFAULT NULL
)


INSERT INTO `stu` (`id`, `sname`) VALUES
(1, 'ram'),
(2, 'ram'),
(3, 'ram'),
(4, 'raj'),
(5, 'raj'),
(6, 'raj');

ANSWER
select sname from (
select (id- round((select count(*)from stu)/2)) as id, sname from stu where id >((select count(*)from stu)/2)
UNION
select * from stu where id<4
) as B order by(id)

Can coalesce return null?

1067

---

In which tcp/ip port does sql server run? Can it be changed?

1038

---

How to change server name in sql server?

1252

---

Why would you call update statistics?

1072

---

What is difference between joins and subqueries?

1171

---

What are drillthrough reports?

161

---

How much is a sql server license?

1009

---

What are security principals used in sql server 2005?

1036

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1095

---

Is null in sql server?

1042

---

What is sql server management studio? : sql server management studio

1124

---

Explain the first normal form(1nf)?

1077

---

What are statistics?

1050

---

How to generate create function script on an existing function?

1179

---

What are database states in ms sql server?

1243

---