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)

What is the security principal at the server level that represents your session?

999

---

Explain the xml support sql server extends?

1023

---

What is temporal data type?

903

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1003

---

What does select 1 mean?

914

---

What is the use of for clause?

1089

---

Can sql servers link to other servers?

1068

---

When would you use it?

971

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

970

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1088

---

What is a cube? : sql server analysis services, ssas

979

---

What is mean by candidate key?

990

---

What are the advantages of using stored procedures?

933

---

What are the basic features of a trigger in ms sql server?

1170

---

what is the difference between count(*) and count(1) ?

1066

---