Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?
2 5231how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);
11 12089i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6
8 9228can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
1 4144select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?
2 6955In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
4 6908suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??
5 8388
What are the benefits of pl sql?
How to add, remove, modify users using sql?
What is sqlite used for?
What is trigger and stored procedure in sql?
Why primary key is required?
What is a sql trace file?
How do I know if I have sql express or standard?
What is the limitation on the block size of pl/sql?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
What is a schema sql?
What is sql injection owasp?
What is the difference between partition and index?
Why join is faster than subquery?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is primary key sql?
