Interested to Buy Any Domain ? << Click Here >> for more details...
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 6389how 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 15607i 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 11583can 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 4911select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?
2 7925In 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 8541suppose 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 10024
How do I run a pl sql program?
What are all the different types of indexes?
What is a sql select statement?
Can a foreign key be a duplicate?
What is a pragma statement?
What is right join in sql?
Compare sql & pl/sql
Why do we use procedures?
Can we use loop in sql?
what is foreign key? : Sql dba
What is materialized view in sql?
How to make a copy values from one column to another in sql?
How do you change a value in sql?
How many types of relationship are there?
Is sql a backend?
