In one table there is 10 records without id num,without
primary key and it is not sorted then how to extract last 6
record from table?
Answers were Sorted based on User's Feedback
CREATE TABLE Sample
(
Col1 varchar(5)
)
insert into Sample values('j')
TABLE:
Col1
j
r
c
r
e
f
g
h
x
j
USING CURSOR: ANSWER
DECLARE @COL1 VARCHAR(5)
DECLARE @COUNT VARCHAR(5)
SET @COUNT=0
DECLARE c1 CURSOR
FOR
SELECT COL1 FROM SAMPLE
OPEN C1
FETCH NEXT FROM C1
INTO @COL1
WHILE @@FETCH_STATUS=0
BEGIN
SET @COUNT=@COUNT+1
IF @COUNT>=5
BEGIN
SELECT @COL1
END
FETCH NEXT FROM C1
INTO @COL1
END
CLOSE C1
DEALLOCATE C1
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / laxman
select * from table_name limit 6;
above query is wrkg in mysql
ex;
select * from emp limit 6;
this one is upto 6
u want 10 limit 10 ;
thts ur choice
select * from emp columnname limit 6;
ok
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / sunil soni
CREATE TABLE Temp(
Col1 varchar(5)
)
insert into Temp values('j')
TABLE:
Col1
j
r
c
r
e
f
g
h
x
j
select top 6 col1 from (select row_number() over(order by
id) as rowid,name from (select rand() as id, name from
@temp) t ) t1 order by t1.rowid desc
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / rangaraj
create table empmaster(ename varchar(34))
insert into empmaster values('r')
select * from empmaster
Query:
select top 6 (ename) from empmaster order by ename desc
Is This Answer Correct ? | 2 Yes | 4 No |
I entered the data in SQL toad version 9.0.1 in English and Arabic language but when i do the query i get the data in Arabic language with (??? question mark) ,please your support.
Difference between Bookmark lookup & RID lookup?
On which table the SSIS SQL Server logs are stored?
How will you Handle Error in SQL SERVER 2008?
How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table
Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??
WHAT IS HTTP 500 Internal Server Error? CAN I SOLVE THIS?
when i save float data value 11.22 but this see in table 11.220000004758456 type ? how to save only two decimal point.
What is the meaning of lock escalation and why/how to stop this?
what is meant by write off and write on in sap?
5 Answers Reliance Communications, Wipro,
Is the company liable to deduct professional tax of directors?
I have table name'temp' in that I wanted to add some partial data for a particular column name 'policyno' where data is existing in that column. Ex.Policyno like 'R-KT-SK- EA-134526' like 100 records. In that 100 records some policynos are just like 134527 I mean with out prefix like'R-KT-SK-EA-' now I wanted add this prefix as 'R-KT-SK- EA-134527' for some 50 records. How can I add partial data?