Answer Posted / rama krishna

If you want nth record from table employee then..

select * from employee where rownum <= n
minus
select * from employee where rownum < n

the above query will suffice.

What is time based sql injection?

1033

---

What is the best partition size for windows 10?

1049

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1132

---

How do I count duplicates in sql?

1176

---

What is the advantage of index in sql?

1015

---

How many types of indexes are there in sql?

1040

---

What is delimiter sql?

1058

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1630

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

1050

---

how to convert numeric values to character strings? : Sql dba

1157

---

What are the types of index in sql?

1118

---

What is an emotional trigger?

1057

---

Inline the values in PL/SQL, what does it mean.?

1274

---

what is 'mysqlcheck'? : Sql dba

1063

---

how many groups of data types? : Sql dba

1075

---