Answer Posted / guest

select rownum,ename,sal,empno from(select ename,sal,empno from
table_name order by sal) group by rownum,ename,sal,empno
having rownum=(select count(*) from table_name

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

895

---

Write a sql query to find the names of employees that begin with ‘a’?

954

---

What are the different dcl commands in sql?

1069

---

What is linq to sql?

1061

---

explain advantages of innodb over myisam. : Sql dba

1085

---

Whis is not false in primary key?

1406

---

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

949

---

What are different categories of sql commands?

1070

---

What is data manipulation language?

1137

---

How many types of literals are available in pl sql?

1047

---

What is the use of index in hive?

963

---

Which sql statement is used to return only different values?

954

---

How are functions and procedures called in PL/SQL?

1132

---

How do I trace sql profiler?

923

---

What are views in sql?

928

---