Select from table without using column name
How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let me know the answer
You can Apply This.
Select * from tablename where signin value("serverhost" "root" "viky")
1. Describe tablename2. Desc tablename3. select * from tablename
Find sequence max value
How to find the max value in a sequence?
If you don't own the sequence, you may look at all_sequences, which shows sequences in other schemas that you have access to:select max_valuefrom sys.all_sequenceswhere sequence_owner = '&sequence_owner' and sequence_name = '&sequence_name'
We can get the MAX value of a sequence by using the data dictionary view 'USER_SEQUENCES' .
i.e. SELECT MAX_VALUE FROM USER_SEQUENCES WHERE SEQUENCE_NAME='NAME_OF_SEQUENCE'
Hi,select * from tab; - means we can see all the tables,right!Is there any option similar to this..?
Select distinct TABLE_NAMEfrom user_tab_columns;
Synonym for Table
How to delete duplicate values from tablefor ex: a table contains 200 rows in that 100 rows are duplicate values, how to delete those 100 rows?
Use this simple querydelete from table1 where rowid not in (select max(rowid) from table1 group by duplicate_col_name)
Hi, 'X' refers here to the table name and 'a' and 'b' are the alias nameDelete from X a where rowid in (select min(rowid) from X b &...
A table has following layout ; city, name , sexhow do you write a query to get the count of male, count of female in a given city xxx.Query result should be in a single row with count of male , count of...
select count(case when sex='male' then 1 end) "male", count(case when sex='female' then 1 end)"male", city from cnt where city = 'bangalore';
SELECT city,DECODE(sex,'M',COUNT(sex),null)male, DECODE(sex,'F',count(sex),null)female FROM test GROUP BY city,sex; This will give the name of city along with corresponding number of male and female on that city.
In SQL. (db2)there is one dept table and other emp tablequestion- select emp name from emp whose dept no. Is not in dept table and it is present in emp table plz tell the query?
select e.ename,e.deptno,d.deptno from emp e,dept d where e.deptno=d.deptno(+);
Select emp_name from emp awhere not exists(select 1  ...
Describe a time when you had to work under pressure.
Do you like working in a team or alone? Explain.
Have you experienced being given too many tasks?
Have you gone above and beyond your job description?
Importance of an MBA for an entrepreneur
Describe a time when you had to listen to someone.
What are the career options available in Software Testing Industry?
What was the most important decision you ever had to make?
What will you do when you are not able to get your message across to your audience?
Provide an example of a goal that you successfully attained.
Ask Interview Question?
Have Career Question?
Ask Only Career questions.