table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
7 8351Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query
3 6001What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
TCS,
1615
Explain procedure to change characterset of a database.
What are number line correlation administrators will use while working with a subquery?
What is blob and text in mysql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is blob datatype?
List the advantages of using stored procedures?
What is the return type of mysqli_query?
What is the contrast between sql and mysql?
What is the default '-sort' order for a sql?
How to Change a users password from unix shell.
What is the advantage of index in sql?
what is dbms? : Sql dba
What is primary and foreign key?
How do I change the max connections in mysql?