what is the output for this query select * from employee where 1=1;4 7830
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 output7 4532
Table 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 query3 4280
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju4 3374
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that
What is the difference between the following two sql
select count(*) from
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.3 3384
Comment,Datatypes are unlimited
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
SQL Server Architecture ?
How to trouble shoot if unable to connect SQL Server
What is Lock table in SQL?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Why we need to use secondry database file? though, we can do same work using primary database file also.
How retrieve field names from the table in SQL through JAVA code?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
How to restore performance issues and how to check?
What are the dis_advantages of stored procedures, triggers, indexes?
How to convert a table data in XML format in sql server?
last function used in MS Access to convert sql what function will use in sql
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?