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 a coalesce function?

1202

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2077

---

What are the different types of upgrades that can be performed in sql server?

1180

---

Explain contrast amongst grouped and non-bunched records?

1038

---

Explain “@@rowcount” and “@@error” in sql server?

1098

---

Explain what is use of dbcc commands?

1064

---

How can you check the level of fragmentation on a table?

1051

---

How do we know if any query is retrieving a large amount of data or very little data?

980

---

What is correlated subquery in sql server?

1078

---

Explain system rowset functions?

1008

---

How to convert numeric expression data types using the cast() function?

1078

---

What is 1nf normalization form?

1043

---

What Is Rdbms?

1169

---

What are the requirements for sql server 2016?

890

---

What are the different editions available in sql server 2000?

1059

---